Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More Oracle

Related Courses

Oracle and XML

Recommended Duration:
3 Days
Version: Oracle 11g and 10g
Course can be taught with Oracle version 9i.
Benefits
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.
Audience
Experienced Oracle developers who need to add and/or enhance XML data in their Oracle-based applications.
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.
Exercises
There are ten machine exercises and three optional exercises.
Major 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