Skip Headers
Oracle® XML DB Developer's Guide
10g Release 2 (10.2)

Part Number B14259-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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()