Send to a Friend
 
Content to send

Oracle and XML

Course Number: 594-JK
Recommended Duration: 3 days

Intended Audience: Experienced Oracle developers who need to add and/or enhance XML data in their Oracle-based applications.

Course Overview

Course appropriate for Oracle 11g and 10g. Course can be taught with Oracle version 9i. There are ten machine exercises and three optional exercises.

Objectives

Attendees will learn to use XML with the Oracle database. Students will learn how XML DB is used to store and retrieve XML data inside the Oracle database.

Prerequisites

Working Oracle SQL and general XML experience of at least six months or completion of “Oracle SQL for Developers”, “Oracle SQL and PL/SQL for Developers”, and “XML Introduction” (or equivalent) course.

Topics

  • XML DB concepts & features
  • Oracle XML and SQL/X functions
  • XML DB repository & versioning
  • XMLType: properties and methods
  • XML Schema
  • Structured and Unstructured XML
  • Hybrid XML Data
  • Oracle 11g Binary XMLType
  • Loading data into XMLType
  • Using XPath with XMLType
  • XMLTransform() & XMLType.transform()
  • UpdateXML(), InsertXML(), AppendChildXML(), InsertXMLBefore(), DeleteXML() and existsNode()
  • Create and Use XMLType views
  • Indexes and XMLType
  • HTTPURIType, DBURIType, XDBURIType
  • XQuery expressions
  • XQuery FLOWR, XPath, XQuery
  • SQL XMLQuery() & XMLTable()
  • Oracle XQuery extension functions
  • Queries: Relational, XMLType, CLOB
  • XML document searches
  • XML and PL/SQL
  • PL/SQL APIs for XMLType
  • XSQL Pages Publishing Framework
  • XQuery with ODP.Net and C#
  • XDB and WebDAV
  • Import/Export XMLType Data
  • Using SQL*Loader with XMLType data
  • XML performance issues

Share with others
Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message

Can't Read? Click to Generate New Code
Enter the verification code shown above into the text box below