List of Examples

3-1 Creating a Table with an XMLType Column

3-2 Creating a Table of XMLType

3-3 Inserting XML Content into an XMLType Table

3-4 Inserting XML Content into an XML Type Table Using Java

3-5 Inserting XML Content into an XMLType Table Using C

3-6 Inserting XML Content Into XML DB Repository Using PL/SQL DBMS_XDB

3-7 XML Schema, PurchaseOrder.xsd

3-8 Annotated XML Schema PurchaseOrder.xsd

3-9 Using the DBMS_XMLSCHEMA Package to Register an XML Schema

3-10 Objects Created During XML Schema Registration

3-11 Creating an XMLType Table that Conforms to an XML Schema

3-12 Using DESCRIBE for an XML Schema-Based XMLType Table

3-13 ORA-19007 Error From Attempting to Insert an Incorrect XML Document

3-14 ORA-19007 When Inserting Incorrect XML Document (Partial Validation)

3-15 Using CHECK Constraint to Force Full XML Schema Validation

3-16 Using BEFORE INSERT Trigger to Enforce Full XML Schema Validation

3-17 Applying Database Integrity Constraints and Triggers to an XMLType Table

3-18 Enforcing Database Integrity When Loading XML Using FTP

3-19 Using object_value to Retrieve an Entire XML Document

3-20 Accessing XML Fragments Using extract()

3-21 Accessing a Text Node Value Matching an XPath Expression Using extractValue()

3-22 Invalid Uses of extractValue()

3-23 Searching XML Content Using the existsNode() Function

3-24 Limiting the Results of a SELECT Using existsNode() and extractValue() in the WHERE Clause

3-25 Finding the Reference for any PurchaseOrder Using extractValue() and existsNode()

3-26 Using XMLSequence() and Table() to view Description Nodes

3-27 Counting the Number of Elements in a Collection Using XMLSequence()

3-28 Counting the Number of Child Elements in an Element Using XMLSequence()

3-29 Creating Relational Views On XML Content

3-30 Using a View to Access Individual Members of a Collection

3-31 SQL queries on XML Content Using Views

3-32 Querying XML Using Views of XML Content

3-33 Updating XML Content Using updateXML()

3-34 Replacing an Entire Element Using updateXML()

3-35 Updating a Node Occurring Multiple Times Within a Collection Using updateXML(): Incorrect Usage

3-36 Updating a Node Occurring Multiple Times Within a Collection Using updateXML(): Correct Usage

3-37 Changing Text Node Values Using updateXML()

3-38 Using an EXPLAIN Plan to Analyze the Selection of PurchaseOrders

3-39 Creating an Index on a Text Node

3-40 Generating the EXPLAIN Plan When Selecting a Collection of LineItem Elements from a Nested Table

3-41 Creating an Index to Improve Query Performance by Allowing Direct Access to the Nested Table

3-42 Generating an EXPLAIN Plan When XPath Rewrite Does Not Occur

3-43 Using SQL/XML Functions to Generate XML

3-44 Forcing Pretty-Printing by Invoking extract() on the Result

3-45 Creating XMLType Views Over Conventional Relational Tables

3-46 Querying XMLType Views

3-47 Accessing DEPARTMENTS Table XML Content Using DBUriType() and getXML()

3-48 Using a Predicate in the XPath Expression to Restrict Which Rows Are Included

3-49 XSLT Style Sheet Example: PurchaseOrder.xsl

3-50 Using transform() to Apply an XSL to an XML Document Stored in an XMLType Table

3-51 Uploading Content into Oracle XML DB Repository Using FTP

3-52 Creating a Text Document Resource Using DBMS_XDB

3-53 Using XDBUriType to Access a Text Document in the Repository

3-54 Using XDBUriType and a Repository Resource to Access Content

3-55 Accessing Schema-Based XML Documents Using the Resource and Namespace Prefixes

3-56 Querying Repository Resource Data Using Ref() and the XMLRef Element

3-57 Selecting XML Document Fragments Based on Metadata, Path, and Content

3-58 Updating the Contents of a Text Document Using UPDATE and updateXML() on the Resource

3-59 Updating a Node in the XML Document Using UPDATE and updateXML()

3-60 Updating XML Schema-Based Documents in the Repository

3-61 Viewing RESOURCE_VIEW and PATH_VIEW Structures

3-62 Accessing Resources Using equals_path() and RESOURCE_VIEW

3-63 Determining the Path to XSL Style Sheets Stored in the Repository

3-64 Counting Resources Under a Path

3-65 Listing the Folder Contents in a Path

3-66 Listing the Links Contained in a Folder

3-67 Finding the Path to Resources in the Repository Containing a PO XML Document

3-68 EXPLAIN Plan Output for a Folder-Restricted Query

4-1 Selecting XMLType Columns using getClobVal()

4-2 Using existsNode() on XMLType

4-3 Using existsNode() to Find a node

4-4 Using extract() to Extract the Value of a Node

4-5 Extracting the Scalar Value of an XML Fragment Using extractValue()

4-6 Querying XMLType Using extractValue() and existsNode()

4-7 Querying Transient XMLType Data

4-8 Extracting Data From an XML Document and Inserting It Into a Table

4-9 Extracting Data from an XML Document and Inserting It Into a Table Using extractValue()

4-10 Searching XML Data with extract() and existsNode()

4-11 Searching XML Data with extractValue()

4-12 Extracting Fragments from XMLType Using extract()

4-13 Updating XMLType Using the UPDATE Statement

4-14 Updating XMLType Using UPDATE and updateXML()

4-15 Updating Multiple Text Nodes and Attribute Values Using updateXML()

4-16 Updating Selected Nodes Within a Collection Using updateXML()

4-17 NULL Updates With updateXML()

4-18 XPATH Rewrite with UpdateXML()

4-19 Rewritten Object Relational Equivalent of XPATH Rewrite with UpdateXML()

4-20 XPath expressions in updateXML() Statement

4-21 Object Relational Equivalent of updateXML() Statement

4-22 Creating Views Using updateXML()

4-23 Using extractValue() to Create an Index on a singleton Element or Attribute

4-24 XPath Re-write of an Index on a singleton Element or Attribute

4-25 Using extractValue() to Create an Index on a repeating Element or Attributes

4-26 Using extract().getStringVal() to Create a Function-Based Index on an extract()

4-27 Problem with using extract().getStringVal() to Create a Function-Based Index on an extract() Function

4-28 Creating a Function-Based Index on a CLOB-based XMLType()

4-29 Queries that use Function-Based indexes

4-30 Creating a Function-Based index on Schema-Based XMLType

4-31 Using CTXXPATH Index and existsNode() for XPath Searching

4-32 Creating and Using Storage Preferences for CTXXPATH Indexes

4-33 Synchronizing the CTXXPATH Index

4-34 Optimizing the CTXXPATH Index

4-35 Creating a CTXXPATH Index on a Schema-Based XMLType Table

4-36 Creating an Oracle Text Index

4-37 Searching XML Data Using CONTAINS

5-1 XML Schema Definition, purchaseOrder.xsd

5-2 XML Document, purchaseOrder.xml Conforming to XML Schema, purchaseOrder.xsd

5-3 Registering an XML Schema Using Package DBMS_XMLSCHEMA

5-4 Creating SQL Object Types to Store XMLType Tables

5-5 Default Table for Global Element PurchaseOrder

5-6 Data Dictionary Table for Registered Schemas

5-7 Deleting the XML Schema Using DBMS_XMLSCHEMA

5-8 Registering A Local XML Schema

5-9 Registering A Global XML Schema

5-10 Creating XML Schema-Based XMLType Tables and Columns

5-11 Specifying CLOB Storage for Schema-Based XMLType Tables and Columns

5-12 Specifying Storage Options for Schema-Based XMLType Tables and Columns Using Structured Storage

5-13 Using Common Schema Annotations

5-14 Results of Registering an Annotated XML Schema

5-15 Querying Metadata from a Registered XML Schema

5-16 Capturing SQL Mapping Using SQLType and SQLName Attributes

5-17 XPath Rewrite

5-18 SELECT Statement and XPath Rewrites

5-19 DML Statement and XPath Rewrites

5-20 CREATE INDEX Statement and XPath Rewrites

5-21 Registering Example Schema

5-22 Mapping Predicates

5-23 Mapping Collection Predicates

5-24 Mapping Collection Predicates, Using existsNode()

5-25 Document Ordering with Collection Traversals

5-26 Handling Namespaces

5-27 Date Format Conversions

5-28 existsNode Mapping with Document Order Maintained

5-29 Rewriting extractValue

5-30 Creating Indexes with extract

5-31 XPath Mapping for extract() with Document Ordering Preserved

6-1 Generating XML Schema: Using generateSchema()

6-2 Adding Unique Constraints to an Attribute's Element

6-3 Oracle XML DB XML Schema: complexType Mapping - Setting SQLInLine Attribute to False for Out-of-Line Storage

6-4 Using Fully Qualified XML Schema URL

6-5 Oracle XML DB XML Schema: complexType Mapping XML Fragments to LOBs

6-6 Inheritance in XML Schema: complexContent as an Extension of complexTypes

6-7 Inheritance in XML Schema: Restrictions in complexTypes

6-8 XML Schema complexType: Mapping complexType to simpleContent

6-9 Oracle XML DB XML Schema: Mapping complexType to Any/AnyAttributes

6-10 Using ora:instanceof-only

6-11 Using ora:instanceof

6-12 Using ora:instanceof in a Heterogeneous Schema Storage

6-13 An XML Schema With Circular Dependency

6-14 XML Schema: Cycling Between complexTypes

6-15 XML Schema: Cycling Between complexTypes, Self-Referencing

6-16 existsNode Mapping with Document Order Maintained

6-17 Rewriting extractValue()

6-18 Creating Indexes with extract

6-19 XPath Mapping for extract() with Document Ordering Preserved

6-20 Cyclic Dependencies

6-21 Using Bind Variables in XPath

6-22 Creating Constraints on Elements in Schema-Based Tables that Occur More than Once Using OCT

7-1 Example XML Schema to be Evolved

7-2 Using DBMS_XMLSCHEMA.CopyEvolve() to Update an XML Schema

8-1 Transforming an XMLType Instance Using XMLTransform() and DBUriType to Get the XSL Style Sheet

8-2 Using XMLTransform() and a Subquery to Retrieve the Style Sheet

8-3 Using Transient Style Sheets and XMLTransform()

8-4 Using isSchemaValid()

8-5 Validating XML Using isSchemaValid()

8-6 Using schemaValidate() Within Triggers

8-7 Using XMLIsValid() Within CHECK Constraints

9-1 Simple CONTAINS Query

9-2 CONTAINS with a Structured Predicate

9-3 CONTAINS Using XML Structure to Restrict the Query

9-4 CONTAINS with Structure Inside Full Text Predicate

9-5 ora:contains with an Arbitrarily Complex Text Query

9-6 CONTAINS Query with Simple Boolean

9-7 CONTAINS Query with Complex Boolean

9-8 CONTAINS Query with Stemming

9-9 CONTAINS Query with Complex Query Expression

9-10 Simple CONTAINS Query with SCORE

9-11 WITHIN

9-12 Nested WITHIN

9-13 WITHIN an Attribute

9-14 WITHIN and AND: Two Words in Some Comment Section

9-15 WITHIN and AND: Two Words in the Same Comment

9-16 WITHIN and AND: No Parentheses

9-17 WITHIN and AND: Parentheses Illustrating Operator Precedence

9-18 Structure Inside Full Text Predicate: INPATH

9-19 Structure Inside Full Text Predicate: INPATH

9-20 INPATH with Complex Path Expression (1)

9-21 INPATH with Complex Path Expression (2)

9-22 Nested INPATH

9-23 Nested INPATH Rewritten

9-24 Simple HASPATH

9-25 HASPATH Equality

9-26 HASPATH with Other Operators

9-27 Using Extract to Scope the Results of a CONTAINS Query

9-28 Using Extract Plus ora:contains to Project the Results of a CONTAINS Query

9-29 Simple CONTEXT Index on PURCHASE_ORDERS Table

9-30 Simple CONTEXT Index on PURCHASE_ORDERS Table with Path Section Group

9-31 Simple CONTEXT Index on PURCHASE_ORDERS_xmltype Table (Defaults to PATH_SECTION_GROUP)

9-32 Simple CONTEXT Index on XMLType Table

9-33 CONTAINS Query on XMLType Table

9-34 CONTAINS: Default Case Matching

9-35 Create a Preference for Mixed Case

9-36 CONTEXT Index on PURCHASE_ORDERS Table, Mixed Case

9-37 CONTAINS: Mixed (Exact) Case Matching

9-38 Simple CONTEXT Index on PURCHASE_ORDERS Table with Path Section Group

9-39 ora:contains with an Arbitrarily Complex Text Query

9-40 ora:contains in existsNode Plus Extract

9-41 Create a Policy to Use with ora:contains

9-42 Query on a Common Word with ora:contains

9-43 Query on a Common Word with ora:contains and Policy my_nostopwords_policy

9-44 ora:contains, Default Case-Sensitivity

9-45 Create a Preference for Mixed Case

9-46 Create a Policy with Mixed Case (Case-Insensitive)

9-47 ora:contains, Case-Sensitive (1)

9-48 ora:contains, Case-Sensitive (2)

9-49 ora:contains in existsNode, Big Table

9-50 Explain Plan: existsNode

9-51 B-Tree Index on ID

9-52 ora:contains in existsNode, Mixed Query

9-53 Explain Plan: existsNode

9-54 ora:contains in existsNode, Big Table

9-55 Explain Plan: existsNode

9-56 Create a CTXXPATH Index on PURCHASE_ORDERS_xmltype_big(DOC)

9-57 Explain Plan: existsNode with CTXXPATH Index

9-58 Equality Predicate in XPath, Big Table

9-59 Gathering Index Statistics

9-60 ora:contains in existsNode

9-61 CREATE TABLE PURCHASE_ORDERS

9-62 CREATE TABLE PURCHASE_ORDERS_xmltype

9-63 CREATE TABLE PURCHASE_ORDERS_xmltype_table

10-1 Creating and Manipulating a DOM Document

10-2 Creating a DOM Document Using sys.xmltype

10-3 Creating an Element Node

10-4 Parsing an XML Document

10-5 Transforming an XML Document Using an XSL Style Sheet

11-1 Inserting data with specified columns

11-2 Updating Data With Key Columns

11-3 Simple deleteXML Example

12-1 XMLType Java: Using JDBC to Query an XMLType Table

12-2 XMLType Java: Selecting XMLType Data

12-3 XMLType Java: Directly Returning XMLType Data

12-4 XMLType Java: Returning XMLType Data and Registering the Output Parameter as XMLType

12-5 XMLType Java: Updating, Inserting, or Deleting XMLType Data

12-6 XMLType Java: Getting Metadata on XMLType

12-7 XMLType Java: Updating an Element in an XMLType Column

12-8 Manipulating an XMLType Column

12-9 Loading a Large XML Document

12-10 Java DOM API for XMLType: Creating a DOM Object and Storing It in the Format Specified by the XML Schema

13-1 Using OCI and C API for XML with Oracle XML DB

13-2 Constructing an XML Schema-Based Document Using DOM API and Saving it to Oracle Database

13-3 Retrieving a Document From Oracle Database and Modifying it Using the DOM API

15-1 XMLElement(): Generating an Element for Each Employee

15-2 XMLElement(): Generating Nested XML

15-3 XMLElement(): Generating an Element for Each Employee with ID and Name Attribute

15-4 XMLElement(): Using Namespaces to Create a Schema-Based XML Document

15-5 XMLElement(): Generating an Element from a User-Defined Type

15-6 XMLForest(): Generating Elements for Each Employee with Name Attribute, Start Date, and Dept as Content

15-7 XMLForest(): Generating an Element from an UDT

15-8 XMLSequence(): Generating One XML Document from Another

15-9 XMLSequence(): Generating An XML Document for Each Row of a Cursor Expression, Using SYS_REFCURSOR Argument

15-10 XMLSequence(): Unnesting Collections in XML Documents into SQL Rows

15-11 XMLConcat(): Returning a Concatenation of XML Elements Used in the Argument Sequence

15-12 XMLConcat(): Returning XML Elements By Concatenating the Elements in the Arguments

15-13 XMLAgg(): Generating Department Elements with a List of Employee Elements

15-14 XMLAgg(): Generating Department Elements, Employee Elements in Each Department, and Employee Dependents

15-15 XMLColAttVal(): Generating an Emp Element For Each Employee with Name Attribute and Elements with Start Date and Dept as Content

15-16 DBMS_XMLGEN: Generating Simple XML

15-17 DBMS_XMLGEN: Generating Simple XML with Pagination

15-18 DBMS_XMLGEN: Generating Complex XML

15-19 DBMS_XMLGEN: Generating Complex XML #2 - Inputting User Defined Types For Nested XML Documents

15-20 DBMS_XMLGEN: Generating a Purchase Order from the Database in XML Format

15-21 DBMS_XMLGEN: Generating a New Context Handle from a Passed-in PL/SQL Ref Cursor

15-22 DBMS_XMLGEN: Specifying Null Handling

15-23 DBMS_XMLGEN : Generating a Hierarchical XML Document Containing Recursive Elements From the Result of a Hierarchical Query (Formed by a CONNECT BY Clause)

15-24 DBMS_XMLGEN : Using setBindValue() to Bind Variables in the Query String for DBMS_XMLGEN

15-25 Using SQL_XMLGEN to Create XML

15-26 SYS_XMLGEN(): Retrieving Employee fname From Employees Table and Generating XML with FNAME Element

15-27 Creating a Formatting Object with createFormat

15-28 SYS_XMLGEN(): Converting a Scalar Value to an XML Document Element Contents

15-29 Generating Default Column Name, ROW

15-30 Overriding the Default Column Name: Supplying an XMLFormat Object to the Operator's First Argument

15-31 SYS_XMLGEN(): Converting a User-Defined Type to XML

15-32 SYS_XMLGEN(): Converting an XMLType Instance

15-33 SYS_XMLGEN(): Using SYS_XMLGEN() with Object Views

15-34 Using XSQL Servlet <xsql:include-xml> and Nested XMLAgg() Functions to Aggregate the Results Into One XML Document

15-35 Using XSQL Servlet <xsql:include-xml, XMLElement(), and XMLAgg() to Generate XML from Oracle Database

15-36 Generating XML Using XSU for Java getXML

15-37 Using XMLAgg ORDER BY Clause

15-38 Returning a Rowset using XMLSequence in the TABLE Clause

16-1 Creating an XMLType View Using the XMLElement() Function

16-2 Creating an XMLType View Using Object Types and SYS_XMLGEN()

16-3 Using Namespace Prefixes in XMLType Views

16-4 Using SQL/XML Generation Functions in Schema-Based XMLType Views

16-5 Creating Schema-Based XMLType Views Over Object Views

16-6 XMLType View: View 2, Wrapping Relational Department Data with Nested Employee Data as XML

16-7 Creating an XMLType View by Restricting Rows From an XMLType Table

16-8 Creating an XMLType View by Transforming an XMLType Table

16-9 Identifying When a View is Implicitly Updatable

16-10 Non-Schema-Based Views Constructed Using SQL/XML

16-11 XML-Schema-Based Views Constructed With SQL/XML

16-12 Non-Schema-Based Views Constructed Using SYS_XMLGEN()

16-13 Non-Schema-Based Views Constructed Using SYS_XMLGEN() on an Object View

16-14 XML-Schema-Based Views Constructed Using Object Types

16-15 Generating XML Schema-Based XML Without Creating Views

17-1 Using UriFactory

17-2 Using HTTPUriType

17-3 Using getContentType() and HttpUriType to Return HTTP Headers

17-4 The Virtual XML Document that Scott Sees

17-5 Specifying Predicate pono=100 With the ROW Node

17-6 Searching for Attribute Values on Object Columns Using DBUri

17-7 Using DBUri to Identify a Whole Table as an XML Document

17-8 Using DBUri to Identify a Particular Row in the Table

17-9 Using DBUri to Identify a Specific Column

17-10 Using DBUri to Identify an Attribute Inside a Column

17-11 Using DBUri to Retrieve Only the Text Value of the Node

17-12 Returning XDBUriType Instance

17-13 Creating XDBUriType, Inserting Values Into a Purchase Order Table and Selecting All the PurchaseOrders

17-14 Retrieving Purchase Orders at a URL Using UriType, getXML() and extractValue()

17-15 Creating URL References to a List of Purchase Orders

17-16 UriFactory: Registering the ecom Protocol

17-17 SYS_DBURIGEN(): Generating a URI of type DBUriType that points to a Column

17-18 Passing Columns With Single Arguments to SYS_DBURIGEN()

17-19 Inserting Database References Using SYS_DBURIGEN()

17-20 Returning a Portion of the Results By Creating a View and Using SYS_DBURIGEN()

17-21 Using SYS_DBURIGEN in the RETURNING Clause to Retrieve the URL of an Object

17-22 URL for Overriding the MIME Type by Generating the contenttype Argument, to Retrieve the empno Column of Table Employee

17-23 Installing DBUri Servlet Under /dburi/*

18-1 Storing Extra Metadata

18-2 Custom Properties on a Resource Document

19-1 DBMS_XDB_VERSION. GetResourceByResId(): First version ID is Returned When Resource'home/index.html' is Makeversioned

19-2 DBMS_XDB_VERSION.MakeVersioned(): Creating a Version-Controlled Resource (VCR)

19-3 Retrieving the Resource ID of the New Version After Check In

19-4 Oracle XML DB: Creating and Updating a Version-Controlled Resource (VCR)

19-5 VCR Checkout

19-6 VCR Checkin

19-7 VCR Uncheckout

20-1 Determining Paths Under the Specified Pathname Argument

20-2 Determining Paths Not Under the Specified Pathname Argument

20-3 Determining Paths Using Multiple Correlations

20-4 Using UNDER_PATH: Given a Path Name, List the Directory Given by the Path Name from the RESOURCE_VIEW

20-5 Using UNDER_PATH: Given a Path Name, Get a Resource From the RESOURCE_VIEW

20-6 Using RESOURCE_VIEW: Given a Path, Get all Relative Path Names for Resources up to Three Levels

20-7 Using UNDER_PATH: Given a Path Name, Get Path and Depth Under a Specified Path from the PATH_VIEW

20-8 Given a Path Name, Get Paths and Link Properties from PATH_VIEW

20-9 Using UNDER_PATH: Given a Path Name, Find all the Paths up to a Certain Number of Levels, Including Links Under a Specified Path from the PATH_VIEW

20-10 Using EQUALS_PATH to Locate a Path

20-11 Retrieve RESID of a Given Resource

20-12 Get the Path Name of a Resource Given Its OID

20-13 Select all Folders Under a Given Path

20-14 Join RESOURCE_VIEW with XMLType table MYPOs

20-15 Creating Resources: Inserting Data Into a Resource

20-16 Creating Resources: Inserting Data Into a Resource

20-17 Deleting Resources

20-18 Deleting Resources With Multiple Links

20-19 Recursively Deleting Paths

20-20 Updating Resources

20-21 Updating a Path in the PATH_VIEW

20-22 Updating DisplayName in RESOURCE_VIEW

20-23 Find All Resources Containing Keywords "Oracle" and "Unix"

20-24 Find All Resources Containing Keyword "Oracle" that are Also Under a Specified Path.

21-1 Deriving the Character Set ID From an IANA Name Using UTL_GDK.CHARSET_MAP

21-2 Using DBMS_XDB to Manage Resources

21-3 Using DBMS_XDB to Manage ACL-Based Security

21-4 Using DBMS_XDB for Configuration Management of Oracle XML DB

22-1 Resource JDBC: Using SQL To Determine Purchase Order Properties

23-1 Creating an ACL Using DBMS_XDB.createResource()

23-2 Setting the ACL of a Resource

23-3 Deleting an ACL

23-4 Updating the Entire ACL

23-5 Updating Existing ACE(s) Using RESOURCE_VIEW

23-6 Retrieving the ACL Document for a Resource

23-7 Retrieving Privileges Granted to the Current User for a Particular Resource

23-8 Checking if the Current User has a Given Set of Privileges on a Resource

23-9 Checking if the Current User Has a Given Set of Privileges Given the ACL and the Resource Owner

23-10 Retrieving the Path of the ACL that Protects a Given Resource

23-11 Retrieving the Paths of All Resources Protected by a Given ACL

23-12 Mapping a Single LDAP User to a Shared DB Schema

23-13 Mapping a Subtree of Users to a Shared DB Schema

23-14 Creating LDAP Groups and Specifying Their Members

23-15 ACL Referencing an LDAP User

23-16 ACL Referencing an LDAP Group

24-1 Modifying the FTP Session's Default Timeout Value

25-1 Writing an Oracle XML DB Servlet

27-1 Loading Very Large XML Documents Into Oracle Database Using SQL*Loader

28-1 Exporting XMLType Data

28-2 Exporting XMLType Tables

28-3 Importing Data from a File

28-4 Exporting XML Data in TABLE Mode

28-5 Importing XML Data in TABLE Mode

29-1 Using AQ and XMLType Queue Payloads: Creating the OverSeas Shipping Queue Table and Queue and Transforming the Representation

29-2 Using AQ and XMLType Queue Payloads: Dequeuing Messages

A-1 Oracle XML DB Configuration File

A-2 Updating the Configuration File Using cfg_update() and cfg_get()

H-1 Loading XML Content into Oracle XML DB Using C