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 the Repository Using PL/SQL DBMS_XDB

3-7 Purchase-Order XML Schema, purchaseOrder.xsd

3-8 Annotated Purchase-Order XML Schema, purchaseOrder.xsd

3-9 Registering an XML Schema with DBMS_XMLSCHEMA.registerSchema

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 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 PurchaseOrder XML Instance Document

3-20 Using OBJECT_VALUE to Retrieve an Entire XML Document

3-21 Accessing XML Fragments Using EXTRACT

3-22 Accessing a Text Node Value Using EXTRACTVALUE

3-23 Invalid Uses of EXTRACTVALUE

3-24 Searching XML Content Using EXISTSNODE

3-25 Limiting the Results of a SELECT Using EXISTSNODE in a WHERE Clause

3-26 Finding the Reference for any PurchaseOrder Using extractValue and existsNode

3-27 Using XMLSEQUENCE and TABLE to View Description Nodes

3-28 Counting the Number of Elements in a Collection Using XMLSEQUENCE

3-29 Counting the Number of Child Elements in an Element Using XMLSEQUENCE

3-30 Creating Relational Views On XML Content

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

3-32 SQL queries on XML Content Using Views

3-33 Querying XML Using Views of XML Content

3-34 Updating XML Content Using UPDATEXML

3-35 Replacing an Entire Element Using UPDATEXML

3-36 Incorrectly Updating a Node That Occurs Multiple Times In a Collection

3-37 Correctly Updating a Node That Occurs Multiple Times In a Collection

3-38 Changing Text Node Values Using UPDATEXML

3-39 Using EXPLAIN PLAN to Analyze the Selection of PurchaseOrders

3-40 Creating an Index on a Text Node

3-41 EXPLAIN PLAN For a Selection of LineItem Elements

3-42 Creating an Index for Direct Access to a Nested Table

3-43 EXPLAIN PLAN Generated When XPath Rewrite Does Not Occur

3-44 Using SQL/XML Functions to Generate XML

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

3-46 Creating XMLType Views Over Conventional Relational Tables

3-47 Querying XMLType Views

3-48 Accessing DEPARTMENTS Table XML Content Using DBURIType and getXML()

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

3-50 XSLT Style Sheet Example: PurchaseOrder.xsl

3-51 Applying a Style Sheet Using TRANSFORM

3-52 Uploading Content into the Repository Using FTP

3-53 Creating a Text Document Resource Using DBMS_XDB

3-54 Using PL/SQL Package DBMS_XDB To Create Folders

3-55 Using XDBURIType to Access a Text Document in the Repository

3-56 Using XDBURIType and a Repository Resource to Access Content

3-57 Accessing XML Documents Using Resource and Namespace Prefixes

3-58 Querying Repository Resource Data Using REF and the XMLRef Element

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

3-60 Updating a Document Using UPDATE and UPDATEXML on the Resource

3-61 Updating a Node in the XML Document Using UPDATE and UPDATEXML

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

3-63 Viewing RESOURCE_VIEW and PATH_VIEW Structures

3-64 Accessing Resources Using EQUALS_PATH and RESOURCE_VIEW

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

3-66 Counting Resources Under a Path

3-67 Listing the Folder Contents in a Path

3-68 Listing the Links Contained in a Folder

3-69 Finding Paths to Resources that Contain Purchase-Order XML Documents

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

4-1 Selecting XMLType Columns Using Method getClobVal()

4-2 Using EXISTSNODE to Find a node

4-3 Purchase-Order XML Document

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 XML Data with EXTRACT, and Inserting It into a Table

4-9 Extracting XML Data with EXTRACTVALUE, and Inserting It into a Table

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

4-11 Searching XML Data with EXTRACTVALUE

4-12 Extracting Fragments From an XMLType Instance Using EXTRACT

4-13 Updating XMLType Using the UPDATE SQL 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 – Element and Attribute

4-18 NULL Updates With UPDATEXML – Text Node

4-19 XPath Expressions in UPDATEXML Expression

4-20 Object Relational Equivalent of UPDATEXML Expression

4-21 Creating Views Using UPDATEXML

4-22 Inserting a LineItem Element into a LineItems Element

4-23 Inserting an Element that Uses a Namespace

4-24 Inserting a LineItem Element Before the First LineItem ELement

4-25 Inserting a Date Element as the Last Child of an Action Element

4-26 Deleting LineItem Element Number 222

4-27 Using EXTRACTVALUE to Create an Index on a Singleton Element or Attribute

4-28 XPath Rewrite of an Index on a Singleton Element or Attribute

4-29 Using extractValue() to Create an Index on a Repeating Element or Attributes

4-30 Using getStringVal() to Create a Function-Based Index on an EXTRACT

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

4-32 Queries that use Function-Based Indexes

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

4-34 Using CTXXPATH Index and EXISTSNODE for XPath Searching

4-35 Creating and Using Storage Preferences for CTXXPATH Indexes

4-36 Synchronizing the CTXXPATH Index

4-37 Optimizing the CTXXPATH Index

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

4-39 Creating an Oracle Text Index

4-40 Searching XML Data Using CONTAINS

5-1 XML Schema Instance purchaseOrder.xsd

5-2 purchaseOrder.XML: Document That Conforms to purchaseOrder.xsd

5-3 Registering an XML Schema with DBMS_XMLSCHEMA.REGISTERSCHEMA

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 an XML Schema with DBMS_XMLSCHEMA.DELETESCHEMA

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

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

6-1 XPath Rewrite

6-2 XPath Rewrite with UPDATEXML

6-3 Rewritten Object Relational Equivalent of XPath Rewrite with UPDATEXML

6-4 SELECT Statement and XPath Rewrites

6-5 DML Statement and XPath Rewrites

6-6 CREATE INDEX Statement and XPath Rewrites

6-7 Creating XML Schema-Based Purchase-Order Data

6-8 Mapping Predicates

6-9 Mapping Collection Predicates

6-10 Mapping Collection Predicates, Using EXISTSNODE

6-11 Document Ordering with Collection Traversals

6-12 Handling Namespaces

6-13 Date Format Conversions

6-14 EXISTSNODE Mapping with Document Order Preserved

6-15 Rewriting EXTRACTVALUE

6-16 Creating Indexes with EXTRACTVALUE

6-17 XPath Mapping for EXTRACT with Document Ordering Preserved

7-1 Generating an XML Schema with Function GENERATESCHEMA

7-2 Adding a Unique Constraint to the Parent Element of an Attribute

7-3 complexType Mapping - Setting SQLInline to False for Out-of-Line Storage

7-4 Using a Fully Qualified XML Schema URL

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

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

7-7 Inheritance in XML Schema: Restrictions in complexTypes

7-8 XML Schema complexType: Mapping complexType to simpleContent

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

7-10 Using ora:instanceof-only

7-11 Using ora:instanceof

7-12 Using ora:instanceof with Heterogeneous XML Schema-Based Data

7-13 An XML Schema With Circular Dependency

7-14 XML Schema: Cycling Between complexTypes

7-15 XML Schema: Cycling Between complexTypes, Self-Reference

7-16 Cyclic Dependencies

7-17 Using Bind Variables in XPath

7-18 Creating Constraints on Repetitive Elements in a Schema-Based Table

8-1 Revised Purchase-Order XML Schema

8-2 evolvePurchaseOrder.xsl: Style Sheet to Update Instance Documents

8-3 Loading Revised XML Schema and XSL Style Sheet

8-4 Using DBMS_XMLSCHEMA.COPYEVOLVE to Update an XML Schema

9-1 Registering XML Schema and Inserting XML Data

9-2 Using XMLTRANSFORM and DBURITYPE to Retrieve a Style Sheet

9-3 Using XMLTRANSFORM and a Subquery to Retrieve a Style Sheet

9-4 Using XMLType.transform() with a Transient Style Sheet

9-5 Using isSchemaValid()

9-6 Validating XML Using isSchemaValid()

9-7 Using schemaValidate() Within Triggers

9-8 Using XMLIsValid() Within CHECK Constraints

10-1 Simple CONTAINS Query

10-2 CONTAINS with a Structured Predicate

10-3 CONTAINS Using XML Structure to Restrict the Query

10-4 CONTAINS with Structure Inside Full-Text Predicate

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

10-6 CONTAINS Query with Simple Boolean

10-7 CONTAINS Query with Complex Boolean

10-8 CONTAINS Query with Stemming

10-9 CONTAINS Query with Complex Query Expression

10-10 Simple CONTAINS Query with SCORE

10-11 WITHIN

10-12 Nested WITHIN

10-13 WITHIN an Attribute

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

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

10-16 WITHIN and AND: No Parentheses

10-17 WITHIN and AND: Parentheses Illustrating Operator Precedence

10-18 Structure Inside Full-Text Predicate: INPATH

10-19 Structure Inside Full-Text Predicate: INPATH

10-20 INPATH with Complex Path Expression (1)

10-21 INPATH with Complex Path Expression (2)

10-22 Nested INPATH

10-23 Nested INPATH Rewritten

10-24 Simple HASPATH

10-25 HASPATH Equality

10-26 HASPATH with Other Operators

10-27 Using EXTRACT to Scope the Results of a CONTAINS Query

10-28 Using EXTRACT and ora:contains to Project the Result of a CONTAINS Query

10-29 Simple CONTEXT Index on Table PURCHASE_ORDERS

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

10-31 Simple CONTEXT Index on Table PURCHASE_ORDERS_xmltype

10-32 Simple CONTEXT Index on XMLType Table

10-33 CONTAINS Query on XMLType Table

10-34 CONTAINS: Default Case Matching

10-35 Create a Preference for Mixed Case

10-36 CONTEXT Index on PURCHASE_ORDERS Table, Mixed Case

10-37 CONTAINS: Mixed (Exact) Case Matching

10-38 Simple CONTEXT Index on purchase_orders Table with Path Section Group

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

10-40 ora:contains in EXISTSNODE and EXTRACT

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

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

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

10-44 ora:contains, Default Case-Sensitivity

10-45 Create a Preference for Mixed Case

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

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

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

10-49 Creating a Heap-Organized Table that Conforms to an XML Schema

10-50 ora:contains in EXISTSNODE, Large Table

10-51 EXPLAIN PLAN: EXISTSNODE

10-52 B-Tree Index on ID

10-53 ora:contains in EXISTSNODE, Mixed Query

10-54 EXPLAIN PLAN: EXISTSNODE

10-55 ora:contains in EXISTSNODE, Large Table

10-56 EXPLAIN PLAN: EXISTSNODE

10-57 Create a CTXXPATH Index on purchase_orders_xmltype_big(doc)

10-58 EXPLAIN PLAN: EXISTSNODE with CTXXPATH Index

10-59 Equality Predicate in XPath, Big Table

10-60 Gathering Index Statistics

10-61 ora:contains in existsNode

10-62 Purchase Order XML Document, po001.xml

10-63 CREATE TABLE purchase_orders

10-64 CREATE TABLE purchase_orders_xmltype

10-65 CREATE TABLE purchase_orders_xmltype_table

10-66 Purchase-Order XML Schema for Full-Text Search Examples

11-1 Creating and Manipulating a DOM Document

11-2 Creating an Element Node and Obtaining Information About It

11-3 Parsing an XML Document

11-4 Transforming an XML Document Using an XSL Style Sheet

12-1 Inserting data with specified columns

12-2 Updating Data With Key Columns

12-3 Simple deleteXML() Example

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

13-2 XMLType Java: Selecting XMLType Data

13-3 XMLType Java: Directly Returning XMLType Data

13-4 XMLType Java: Returning XMLType Data

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

13-6 XMLType Java: Getting Metadata on XMLType

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

13-8 Manipulating an XMLType Column

13-9 Loading a Large XML Document

13-10 Creating a DOM Object with the Java DOM API

14-1 Using OCIXmlDbInitXmlCtx() and OCIXmlDbFreeXmlCtx()

14-2 Using the DOM to Count Ordered Parts

15-1 Retrieve XMLType Data to .NET

16-1 XMLELEMENT: Formatting a Date

16-2 XMLELEMENT: Generating an Element for Each Employee

16-3 XMLELEMENT: Generating Nested XML

16-4 XMLELEMENT: Generating Employee Elements with ID and Name Attributes

16-5 XMLELEMENT: Using Namespaces to Create a Schema-Based XML Document

16-6 XMLELEMENT: Generating an Element from a User-Defined Datatype Instance

16-7 XMLFOREST: Generating Elements with Attribute and Child Elements

16-8 XMLFOREST: Generating an Element from a User-Defined Datatype Instance

16-9 XMLSEQUENCE Returns Only Top-Level Element Nodes

16-10 XMLSEQUENCE: Generating One XML Document from Another

16-11 XMLSEQUENCE: Generate a Document for Each Row of a Cursor

16-12 XMLSEQUENCE: Unnesting Collections in XML Documents into SQL Rows

16-13 XMLCONCAT: Concatenating XMLType Instances from a Sequence

16-14 XMLCONCAT: Concatenating XML Elements

16-15 XMLAGG: Generating Department Elements with a List of Employee Elements

16-16 XMLAGG: Generating Nested Elements

16-17 Using XMLPI

16-18 Using XMLCOMMENT

16-19 Using XMLRoot

16-20 Using XMLSERIALIZE

16-21 Using XMLPARSE

16-22 XMLCOLATTVAL: Generating Elements with Attribute and Child Elements

16-23 Using XMLCDATA

16-24 DBMS_XMLGEN: Generating Simple XML

16-25 DBMS_XMLGEN: Generating Simple XML with Pagination (fetch)

16-26 DBMS_XMLGEN: Generating Nested XML With Object Types

16-27 DBMS_XMLGEN: Generating Nested XML With User-Defined Datatype Instances

16-28 DBMS_XMLGEN: Generating an XML Purchase Order

16-29 DBMS_XMLGEN: Generating a New Context Handle from a Ref Cursor

16-30 DBMS_XMLGEN: Specifying NULL Handling

16-31 DBMS_XMLGEN : Generating Recursive XML with a Hierarchical Query

16-32 DBMS_XMLGEN : Binding Query Variables with setBindValue()

16-33 Using SYS_XMLGEN to Create XML

16-34 SYS_XMLGEN: Generating an XML Element from a Database Column

16-35 SYS_XMLGEN: Converting a Scalar Value to XML Element Contents

16-36 SYS_XMLGEN: Default Element Name ROW

16-37 Overriding the Default Element Name: Using SYS_XMLGEN with XMLFormat

16-38 SYS_XMLGEN: Converting a User-Defined Datatype Instance to XML

16-39 SYS_XMLGEN: Converting an XMLType Instance

16-40 Using SYS_XMLGEN with Object Views

16-41 Using XSQL Servlet <xsql:include-xml> with Nested XMLAgg Functions

16-42 Using XSQL Servlet <xsql:include-xml> with XMLElement and XMLAgg

16-43 Using XMLAGG ORDER BY Clause

16-44 Returning a Rowset using XMLSEQUENCE, EXTRACT, and TABLE

17-1 Creating Resources for Examples

17-2 XMLQuery Applied to a Sequence of Items of Different Types

17-3 FLOWR Expression Using For, Let, Order By, Where, and Return

17-4 FLOWR Expression Using Built-In Functions

17-5 Using ora:view to Query Relational Tables as XML Views

17-6 Using ora:view in a Nested FLWOR Query

17-7 Using ora:view with XMLTable to Query a Relational Table as XML

17-8 Using XMLQuery with PASSING Clause, to Query an XMLType Column

17-9 Using XMLTable with XML Schema-Based Data

17-10 Using XMLQuery with Schema-Based Data

17-11 Using XMLTable with PASSING and COLUMNS Clauses

17-12 Using XMLTable to Shred XML Collection Elements into Relational Data

17-13 Using XMLTable with the NAMESPACES Clause

17-14 Optimization of XMLQuery with ora:view

17-15 Optimization of XMLTable with ora:view

17-16 Optimization of XMLQuery with Schema-Based XMLType Data

17-17 Optimization of XMLTable with Schema-Based XMLType Data

17-18 Static Type-Checking of XQuery Expressions: ora:view

17-19 Static Type-Checking of XQuery Expressions: Schema-Based XML

17-20 Using the SQL*Plus XQUERY Command

17-21 Using XQuery with PL/SQL

17-22 Using XQuery with JDBC

17-23 Using XQuery with ODP.NET and C#

18-1 Creating an XMLType View Using XMLELEMENT

18-2 Creating an XMLType View Using Object Types and SYS_XMLGEN

18-3 Registering XML Schema emp_simple.xsd

18-4 Creating an XMLType View Using SQL/XML Functions

18-5 Querying an XMLType View

18-6 Using Namespace Prefixes in XMLType Views

18-7 Using SQL/XML Generation Functions in Schema-Based XMLType Views

18-8 Creating Object Types for Schema-Based XMLType Views

18-9 Generating an XML Schema with DBMS_XMLSCHEMA.GENERATESCHEMA

18-10 Registering XML Schema emp_complex.xsd

18-11 Creating an XMLType View

18-12 Creating an Object View and an XMLType View on the Object View

18-13 Creating Object Types

18-14 Registering XML Schema dept_complex.xsd

18-15 Creating XMLType Views on Relational Tables

18-16 Creating XMLType Views Using SQL/XML Functions

18-17 Creating an XMLType View by Restricting Rows From an XMLType Table

18-18 Creating an XMLType View by Transforming an XMLType Table

18-19 Identifying When a View is Implicitly Updatable

18-20 Non-Schema-Based Views Constructed Using SQL/XML

18-21 XML-Schema-Based Views Constructed With SQL/XML

18-22 Non-Schema-Based Views Constructed Using SYS_XMLGEN

18-23 Non-Schema-Based Views Constructed Using SYS_XMLGEN on an Object View

18-24 XML-Schema-Based Views Constructed Using Object Types

18-25 Generating XML Schema-Based XML Without Creating Views

19-1 Using HTTPURIType Method getContentType()

19-2 Creating and Querying a URI Column

19-3 Using Different Kinds of URI, Created in Different Ways

19-4 Using an XDBUri to Access a Repository Resource by URI

19-5 Using getXML() with EXTRACTVALUE

19-6 Using a DBUri to Target a Complete Table

19-7 Using a DBUri to Target a Particular Row in a Table

19-8 Using a DBUri to Target a Specific Column

19-9 Using a DBUri to Target an Object Column with Specific Attribute Values

19-10 Using a DBUri to Retrieve Only the Text Value of a Node

19-11 Using a DBUri to Target a Collection

19-12 URIFACTORY: Registering the ECOM Protocol

19-13 SYS_DBURIGEN: Generating a DBUri that Targets a Column

19-14 Passing Columns With Single Arguments to SYS_DBURIGEN

19-15 Inserting Database References Using SYS_DBURIGEN

19-16 Returning a Portion of the Results By Creating a View and Using SYS_DBURIGEN

19-17 Using SYS_DBURIGEN in the RETURNING Clause to Retrieve a URL

19-18 Using a URL to Override the MIME Type

19-19 Changing the Installation Location of DBUriServlet

19-20 Restricting Servlet Access to a Database Role

19-21 Registering a Handler for a DBUri Prefix

21-1 Using DBMS_XDB_VERSION.GetResourceByResId To Retrieve a Resource

21-2 Using DBMS_XDB_VERSION.MakeVersioned To Create a VCR

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

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

21-5 VCR Check-Out

21-6 VCR Check-In

21-7 VCR UnCheckOut()

22-1 Determining Paths Under a Path: Relative

22-2 Determining Paths Under a Path: Absolute

22-3 Determining Paths Not Under a Path

22-4 Determining Paths Using Multiple Correlations

22-5 Using ANY_PATH with LIKE

22-6 Relative Path Names for Three Levels of Resources

22-7 Extracting Resource Metadata using UNDER_PATH

22-8 Using Functions PATH and DEPTH with PATH_VIEW

22-9 Extracting Link and Resource Information from PATH_VIEW

22-10 All Paths to a Certain Depth Under a Path

22-11 Using EQUALS_PATH to Locate a Path

22-12 Retrieve RESID of a Given Resource

22-13 Obtaining the Path Name of a Resource from its RESID

22-14 Folders Under a Given Path

22-15 Joining RESOURCE_VIEW with an XMLType Table

22-16 Deleting Resources

22-17 Deleting Links to Resources

22-18 Deleting a Nonempty Folder

22-19 Updating a Resource

22-20 Updating a Path in the PATH_VIEW

22-21 Updating Resources Based on Attributes

22-22 Finding Resources Inside a Folder

22-23 Copying Resources

22-24 Find All Resources Containing "Paper"

22-25 Find All Resources Containing "Paper" that are Under a Specified Path

23-1 Using DBMS_XDB to Manage Resources

23-2 Using Procedure DBMS_XDB.getACLDocument

23-3 Using Procedure DBMS_XDB.setACL

23-4 Using Function DBMS_XDB.changePrivileges

23-5 Using Function DBMS_XDB.changePrivileges

23-6 Using Function DBMS_XDB.cfg_get

23-7 Using Procedure DBMS_XDB.cfg_update

24-1 Creating an ACL Using DBMS_XDB.createResource

24-2 Setting the ACL of a Resource

24-3 Deleting an ACL

24-4 Updating (Replacing) an Access Control List

24-5 Appending ACEs to an Access Control List

24-6 Deleting an ACE from an Access Control List

24-7 Retrieving the ACL Document for a Resource

24-8 Retrieving Privileges Granted to the Current User for a Particular Resource

24-9 Checking If a User Has a Certain Privileges on a Resource

24-10 Checking User Privileges using ACLCheckPrivileges

24-11 Retrieving the Path of the ACL that Protects a Given Resource

24-12 Retrieving the Paths of All Resources Protected by a Given ACL

24-13 ACL Referencing an LDAP User

24-14 ACL Referencing an LDAP Group

25-1 Navigating ASM Folders

25-2 Transferring ASM Files Between Databases with FTP proxy Method

25-3 Modifying the Default Timeout Value of an FTP Session

26-1 Register an XML Schema for Technical Photo Information

26-2 Register an XML Schema for Photo Categorization

26-3 Add Metadata to a Resource – Technical Photo Information

26-4 Add Metadata to a Resource – Photo Content Categories

26-5 Delete Specific Metadata from a Resource

26-6 Add Metadata to a Resource Using DML with RESOURCE_VIEW

26-7 Add Metadata with WebDAV PROPPATCH

26-8 Query XML Schema-Based Resource Metadata

26-9 Add Non-Schema-Based Metadata to a Resource

27-1 Writing an Oracle XML DB Servlet

28-1 Oracle XML DB Configuration File

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

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

30-1 Exporting XMLType Data

30-2 Exporting XMLType Tables

30-3 Importing Data from a File

30-4 Exporting XML Data in TABLE Mode

30-5 Importing XML Data in TABLE Mode

31-1 XMLType and AQ: Creating a Table and Queue, and Transforming Messages

31-2 XMLType and AQ: Dequeuing Messages

D-1 Annotated Purchase-Order XML Schema, purchaseOrder.xsd

D-2 Revised Purchase-Order XML Schema

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

D-4 Using OCIXmlDbInitXmlCtx() and OCIXmlDbFreeXmlCtx()