Oracle Database 10g: Use XML for SQL and PL/SQL Deve.

Oracle University

Oracle Database 10g: Use XML for SQL and PL/SQL Developers


3 Days


What you will learn

Oracle provides PL/SQL developers with XML tools, which work inside the Oracle Database. In this course, students

learn to use XML technology with PL/SQL for Application Development. This course covers the XML features and

utilities available for the Oracle Database 10g Release 2, that can be used to develop PL/SQL applications.

The focus of this course is Oracle XML DB including packages supporting Oracle XML DB. Students learn to store,

retrieve, search, generate and manipulate XML data in the Oracle Database. This course emphasizes XQuery, a

language designed to query XML data from both XML files and from relational databases. Students also learn how to

optimize the performance of XPath and XQuery expressions. This course covers importing and exporting XML data in

Oracle XML DB.

Learn To:

Use Oracle XML DB Repository

Search and Retrieve XML Data

Manage XML Storage in Oracle XML DB

Manipulate and Generate XML Data

Use XQuery



Application Developers

Database Administrators


End Users

PL/SQL Developer


Required Prerequisites

Oracle Database 10g: SQL Fundamentals I

Oracle Database 10g: Program with PL/SQL

Oracle 10g: XML Fundamentals

Suggested Prerequisites

Experience in basic use of Oracle RDBMS, including SQL DDL and DML, and PL/SQL

XML Fundamentals

Course Objectives

Explain the basic concepts of Oracle XML DB

Use Oracle XML DB Repository

Manage XML Storage in Oracle XML DB

Use XQuery

Search and Retrieve XML Data

Manipulate XML Data

Generate XML Data

Tune the performance of XPath and XQuery expressions


Import and Export XML Data

Course Topics

Introducing XML for Application Developers

Oracle XML DB basic concepts, features and terminology

Oracle XML DB Repository

Overview of Oracle XML DB Repository

Creating and Accessing Resources

Managing Oracle XML DB Versioning

Accessing Oracle XML DB repository data using standard Internet protocols

Managing XML Storage

Choosing Native XML Storage

Unstructured versus structured storage

Using XMLType view for relational data

Using hybrid storage mapping

Using out-of-line storage

Storing collections in out-of-line tables

Specifying SQL constraints

Adding constraints on repetitive elements

Advanced XML Schema

Inheritance in the XML Schema

Managing cyclical definitions in XML Schema

XML Schema Evolution


XQuery: Introduction

XQuery Data Model

Using XMLQuery(), XMLTable(), and ora:view functions

Using XQuery Expressions

Using XQuery functions and operators

Searching and Retrieving XML Data

Retrieve XML data

Querying Database: Relational Data

Querying Database: XMLType Data

Querying Database: CLOB Data

Searching an XML Document

Using XPath based Search

Using Full Text Search

Advanced XQuery

Using XQuery to Generate XML

Using XQuery to Transform XML

Using XQuery For Querying XML

XQuery Support in SQL*Plus

Using XQuery with PL/SQL: Binding Dynamic Variables

Using Namespace with XQuery

Manipulating and Generating XML Data

Using SQL functions to update XML data


Generating XML using new SQL/XML functions

Generating XML using DBMS_XMLGEN package

Understanding and Optimizing XPath and XQuery Rewrite

Overview of XPath Rewrite

XPath rewrite benefits

Instances where XPath rewrite occur and does not occur

XPath rewrite process

Detecting XPath Rewrite

XPath rewrite of SQL Functions

XQuery Rewrite

Tuning the performance of XQuery Expressions


Introducing PL/SQL APIs for XMLType

Document Object Model(DOM)

Using DBMS_XMLDOM to create a DOM document.

Using DBMS_XMLPARSER to access the contents and structure of XML documents

Using DBMS_XSLPROCESSOR for transforming an XML documents

Importing/Exporting XML Data

Loading XMLType data using SQL*Loader

Importing and exporting XMLType data

Creating XMLType Queue

Enqueue and dequeue XML messages





pearson vueISO 9001