List of Examples

• 1-1 Listener Status with FTP and HTTP(S) Protocol Support Enabled
• 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 Creating an XMLType Table for Nested Collections
• 3-13 Using DESCRIBE for an XML Schema-Based XMLType Table
• 3-14 Error From Attempting to Insert an Incorrect XML Document
• 3-15 Error When Inserting Incorrect XML Document (Partial Validation)
• 3-16 Using CHECK Constraint to Force Full XML Schema Validation
• 3-17 Using BEFORE INSERT Trigger to Enforce Full XML Schema Validation
• 3-18 Using a Virtual Column to Constrain an XMLType Table Stored as Binary XML
• 3-19 Database Integrity Constraints and Triggers for an XMLType Table Stored Object-Relationally
• 3-20 Enforcing Database Integrity When Loading XML Using FTP
• 3-21 PurchaseOrder XML Instance Document
• 3-22 Using OBJECT_VALUE to Retrieve an Entire XML Document
• 3-23 Accessing XML Fragments Using EXTRACT
• 3-24 Accessing a Text Node Value Using XMLCAST
• 3-25 Using XMLTABLE to Access Description Nodes
• 3-26 Counting the Number of Elements in a Collection Using XMLTABLE
• 3-27 Counting the Number of Child Elements in an Element Using XMLTABLE
• 3-28 Searching XML Content Using XMLExists
• 3-29 Limiting the Results of a SELECT Using XMLExists in a WHERE Clause
• 3-30 Finding the Reference for any PurchaseOrder Using XMLQuery and XMLExists
• 3-31 Creating a Relational View On XML Content
• 3-32 Using a View to Access Individual Members of a Collection
• 3-33 SQL queries on XML Content Using Views
• 3-34 Querying XML Using Views of XML Content
• 3-35 Updating XML Content Using UPDATEXML
• 3-36 Replacing an Entire Element Using UPDATEXML
• 3-37 Incorrectly Updating a Node That Occurs Multiple Times In a Collection
• 3-38 Correctly Updating a Node That Occurs Multiple Times In a Collection
• 3-39 Changing Text Node Values Using UPDATEXML
• 3-40 Using EXPLAIN PLAN to Analyze the Selection of Purchase Orders
• 3-41 Creating an Index on a Text Node
• 3-42 Explain Plan Showing Use of a B-Tree Index
• 3-43 EXPLAIN PLAN for a Selection of Collection Elements
• 3-44 Creating an Index for Direct Access to an Ordered Collection Table
• 3-45 EXPLAIN PLAN Generated When XPath Rewrite Does Not Occur
• 3-46 Using SQL/XML Functions to Generate XML
• 3-47 Creating XMLType Views Over Conventional Relational Tables
• 3-48 Querying XMLType Views
• 3-49 Accessing DEPARTMENTS Table XML Content Using DBURIType and getXML()
• 3-50 Using a Predicate in the XPath Expression to Restrict Which Rows Are Included
• 3-51 XSLT Style Sheet Example: PurchaseOrder.xsl
• 3-52 Applying a Style Sheet Using TRANSFORM
• 3-53 Uploading Content into the Repository Using FTP
• 3-54 Creating a Text Document Resource Using DBMS_XDB
• 3-55 Using PL/SQL Package DBMS_XDB To Create Folders
• 3-56 Using XDBURIType to Access a Text Document in the Repository
• 3-57 Using XDBURIType and a Repository Resource to Access Content
• 3-58 Accessing XML Documents Using Resource and Namespace Prefixes
• 3-59 Querying Repository Resource Data Using SQL Function REF and Element XMLRef
• 3-60 Selecting XML Document Fragments Based on Metadata, Path, and Content
• 3-61 Updating a Document Using UPDATE and UPDATEXML on the Resource
• 3-62 Updating a Node in the XML Document Using UPDATE and UPDATEXML
• 3-63 Updating XML Schema-Based Documents in the Repository
• 3-64 Viewing RESOURCE_VIEW and PATH_VIEW Structures
• 3-65 Accessing Resources Using EQUALS_PATH and RESOURCE_VIEW
• 3-66 Determining the Path to XSL Style Sheets Stored in the Repository
• 3-67 Counting Resources Under a Path
• 3-68 Listing the Folder Contents in a Path
• 3-69 Listing the Links Contained in a Folder
• 3-70 Finding Paths to Resources that Contain Purchase-Order XML Documents
• 3-71 EXPLAIN Plan Output for a Folder-Restricted Query
• 4-1 Selecting XMLType Columns Using Method getCLOBVal()
• 4-2 Using XMLExists to Find a node
• 4-3 Using EXISTSNODE to Find a node
• 4-4 Purchase-Order XML Document
• 4-5 Using EXTRACT to Extract the Value of a Node
• 4-6 Extracting the Scalar Value of an XML Fragment Using XMLCAST
• 4-7 Extracting the Scalar Value of an XML Fragment Using EXTRACTVALUE
• 4-8 Invalid Uses of EXTRACTVALUE
• 4-9 Querying XMLType Using EXTRACTVALUE and EXISTSNODE
• 4-10 Querying Transient XMLType Data
• 4-11 Extracting XML Data with XMLTable, and Inserting It into a Database Table
• 4-12 Extracting XML Data with EXTRACTVALUE, and Inserting It into a Table
• 4-13 Searching XML Data with XMLType Methods extract() and existsNode()
• 4-14 Searching XML Data with EXTRACTVALUE
• 4-15 Extracting Fragments From an XMLType Instance Using EXTRACT
• 4-16 Updating XMLType Using SQL UPDATE Statement
• 4-17 Updating XMLType Using UPDATE and UPDATEXML
• 4-18 Updating Multiple Text Nodes and Attribute Values Using UPDATEXML
• 4-19 Updating Selected Nodes Within a Collection Using UPDATEXML
• 4-20 NULL Updates With UPDATEXML - Element and Attribute
• 4-21 NULL Updates With UPDATEXML - Text Node
• 4-22 XPath Expressions in UPDATEXML Expression
• 4-23 Object Relational Equivalent of UPDATEXML Expression
• 4-24 Creating Views Using UPDATEXML
• 4-25 Inserting a LineItem Element into a LineItems Element
• 4-26 Inserting an Element that Uses a Namespace
• 4-27 Inserting a LineItem Element Before the First LineItem ELement
• 4-28 Inserting a Date Element as the Last Child of an Action Element
• 4-29 Deleting LineItem Element Number 222
• 5-1 Creating a Function-Based Index on a CLOB XMLType Instance
• 5-2 Function-Based Index Is Used Only by a Matching Query
• 5-3 CREATE INDEX with EXTRACTVALUE on a Singleton Element or Attribute
• 5-4 XPath Rewrite of an EXTRACTVALUE Index on a Singleton Element or Attribute
• 5-5 Trying to Create a Function-Based Index on a Repeating Attribute
• 5-6 Creating a Function-Based Index Using EXTRACT and getStringVal()
• 5-7 Function-Based Index on Concatenated Nodes
• 5-8 Path Table Contents for Two Purchase Orders
• 5-9 Creating an XMLIndex Index on XMLType Unstructured Storage
• 5-10 Creating an XMLIndex Index on XMLType Hybrid Storage
• 5-11 XML Schema Fragment that Maps LineItems to CLOB Storage
• 5-12 Obtaining the Name of an XMLIndex Index on a Particular Table
• 5-13 Renaming and Dropping an XMLIndex Index
• 5-14 Naming the Path Table of an XMLIndex Index
• 5-15 Determining the System-Generated Name of an XMLIndex Path Table
• 5-16 Specifying Storage Options When Creating an XMLIndex Index
• 5-17 Determining the Names of the Secondary Indexes of an XMLIndex Index
• 5-18 Creating a Function-Based Index on Path-Table Column VALUE
• 5-19 Trying to Create a Numeric Index on Path-Table Column VALUE Directly
• 5-20 Creating a Numeric Index on Column VALUE with Procedure createNumberIndex
• 5-21 Creating a Date Index on Column VALUE with Procedure createDateIndex
• 5-22 Creating an Oracle Text CONTEXT Index on Path-Table Column VALUE
• 5-23 Showing All Secondary Indexes on an XMLIndex Path Table
• 5-24 Examining an Explain Plan to See If XMLIndex Is Used
• 5-25 Obtaining the Name of an XMLIndex Index from Its Path-Table Name
• 5-26 Using XMLIndex to Extract an XML Fragment
• 5-27 Using Optimizer Hints to Turn Off XMLIndex
• 5-28 XMLIndex Path Subsetting With CREATE INDEX
• 5-29 XMLIndex Path Subsetting With ALTER INDEX
• 5-30 XMLIndex Path Subsetting Using a Namespace Prefix
• 5-31 Using XMLIndex When Querying Resource Data
• 5-32 Using XMLIndex When Querying Resource Metadata
• 5-33 Creating an XMLIndex Index in Parallel
• 5-34 Using Different PARALLEL Degrees for XMLIndex Internal Objects
• 5-35 Specifying Deferred Synchronization for XMLIndex
• 5-36 Manually Synchronizing an XMLIndex Index Using SYNCINDEX
• 5-37 Automatic Collection of Statistics on XMLIndex Objects
• 5-38 Creating an Oracle Text Index
• 5-39 Searching XML Data Using SQL Function CONTAINS
• 5-40 Using an Oracle Text Index and an XMLIndex Index
• 6-1 XML Schema Instance purchaseOrder.xsd
• 6-2 purchaseOrder.xml: Document That Conforms to purchaseOrder.xsd
• 6-3 Registering an XML Schema with DBMS_XMLSCHEMA.REGISTERSCHEMA
• 6-4 Creating SQL Object Types to Store XMLType Tables
• 6-5 Default Table for Global Element PurchaseOrder
• 6-6 Data Dictionary Table for Registered Schemas
• 6-7 Deleting an XML Schema with DBMS_XMLSCHEMA.DELETESCHEMA
• 6-8 Registering a Local XML Schema
• 6-9 Registering a Global XML Schema
• 6-10 XML Schema Defining Security-Class Documents
• 6-11 Security Class Document Associated With the XML Schema
• 6-12 XML Schema With Attribute xdb:translate Set to True for a Single-Valued Element
• 6-13 Security Class Document After Translation
• 6-14 XML Schema With Attribute xdb:translate Set to True for a Multi-Valued Element
• 6-15 Security Class Document for an XML Schema With Multiple-Valued Elements
• 6-16 Inserting a Document With No Language Information
• 6-17 Security Class Document After Insertion
• 6-18 Inserting a Document With Language Information
• 6-19 Security Class Document After Insertion
• 6-20 Creating XML Schema-Based XMLType Tables and Columns
• 6-21 Specifying CLOB Storage for Schema-Based XMLType Tables and Columns
• 6-22 Specifying Structured Storage Options for Schema-Based XMLType Tables and Columns
• 6-23 Using Common Schema Annotations
• 6-24 Registering an Annotated XML Schema
• 6-25 Querying Metadata from a Registered XML Schema
• 6-26 Mapping XML Schema Data Types to SQL Data Types Using Attribute SQLType
• 7-1 XPath Rewrite
• 7-2 XPath Rewrite with UPDATEXML
• 7-3 Rewritten Object Relational Equivalent of XPath Rewrite with UPDATEXML
• 7-4 SELECT Statement and XPath Rewrite
• 7-5 DML Statement and XPath Rewrite
• 7-6 CREATE INDEX Statement and XPath Rewrite
• 7-7 Creating XML Schema-Based Purchase-Order Data
• 7-8 Mapping Predicates
• 7-9 Mapping Collection Predicates
• 7-10 Mapping Collection Predicates, Using EXISTSNODE
• 7-11 Document Ordering with Collection Traversals
• 7-12 Handling Namespaces
• 7-13 Date Format Conversions
• 7-14 EXISTSNODE Mapping with Document Order Preserved
• 7-15 Rewriting EXTRACTVALUE
• 7-16 Creating Indexes with EXTRACTVALUE
• 7-17 XPath Mapping for EXTRACT with Document Ordering Preserved
• 8-1 Generating an XML Schema with Function GENERATESCHEMA
• 8-2 Adding a Unique Constraint to the Parent Element of an Attribute
• 8-3 Setting SQLInline to False for Out-Of-Line Storage
• 8-4 Querying an Out-Of-Line Table
• 8-5 XPath Rewrite for an Out-Of-Line Table
• 8-6 Using an Index with an Out-Of-Line Table
• 8-7 Storing a Collection Out of Line
• 8-8 Renaming an Intermediate Table of REF Values
• 8-9 XPath Rewrite for an Out-Of-Line Collection
• 8-10 XPath Rewrite for an Out-Of-Line Collection, with Index on REFs
• 8-11 Using a Fully Qualified XML Schema URL
• 8-12 Oracle XML DB XML Schema: Mapping complexType XML Fragments to LOBs
• 8-13 Inheritance in XML Schema: complexContent as an Extension of complexTypes
• 8-14 Inheritance in XML Schema: Restrictions in complexTypes
• 8-15 XML Schema complexType: Mapping complexType to simpleContent
• 8-16 Oracle XML DB XML Schema: Mapping complexType to any/anyAttribute
• 8-17 Using ora:instanceof-only
• 8-18 Using ora:instanceof
• 8-19 Using ora:instanceof with Heterogeneous XML Schema-Based Data
• 8-20 An XML Schema With Circular Dependency
• 8-21 XML Schema: Cycling Between complexTypes
• 8-22 XML Schema: Cycling Between complexTypes, Self-Reference
• 8-23 Cyclic Dependencies
• 8-24 Recursive Schema
• 8-25 Out-of-line Table
• 8-26 Invalid Default Table Sharing
• 8-27 Using Bind Variables in XPath
• 9-1 Revised Purchase-Order XML Schema
• 9-2 evolvePurchaseOrder.xsl: Style Sheet to Update Instance Documents
• 9-3 Loading Revised XML Schema and XSL Style Sheet
• 9-4 Using DBMS_XMLSCHEMA.COPYEVOLVE to Update an XML Schema
• 9-5 Splitting a Complex Type into Two Complex Types
• 9-6 diffXML Parameter Document
• 10-1 Registering XML Schema and Inserting XML Data
• 10-2 Using XMLTRANSFORM and DBURITYPE to Retrieve a Style Sheet
• 10-3 Using XMLTRANSFORM and a Subquery to Retrieve a Style Sheet
• 10-4 Using Method transform() with a Transient Style Sheet
• 10-5 Using Method isSchemaValid()
• 10-6 Validating XML Using Method isSchemaValid()
• 10-7 Using Method schemaValidate() Within Triggers
• 10-8 Using PL/SQL Function XMLISVALID Within CHECK Constraints
• 11-1 Simple CONTAINS Query
• 11-2 CONTAINS With a Structured Predicate
• 11-3 CONTAINS Using XML Structure to Restrict the Query
• 11-4 CONTAINS With Structure Inside Full-Text Predicate
• 11-5 ora:contains with an Arbitrarily Complex Text Query
• 11-6 CONTAINS Query with Simple Boolean
• 11-7 CONTAINS Query with Complex Boolean
• 11-8 CONTAINS Query with Stemming
• 11-9 CONTAINS Query with Complex Query Expression
• 11-10 Simple CONTAINS Query with SCORE
• 11-11 WITHIN
• 11-12 Nested WITHIN
• 11-13 WITHIN an Attribute
• 11-14 WITHIN and AND: Two Words in Some Comment Section
• 11-15 WITHIN and AND: Two Words in the Same Comment
• 11-16 WITHIN and AND: No Parentheses
• 11-17 WITHIN and AND: Parentheses Illustrating Operator Precedence
• 11-18 Structure Inside Full-Text Predicate: INPATH
• 11-19 Structure Inside Full-Text Predicate: INPATH
• 11-20 INPATH with Complex Path Expression (1)
• 11-21 INPATH with Complex Path Expression (2)
• 11-22 Nested INPATH
• 11-23 Nested INPATH Rewritten
• 11-24 Simple HASPATH
• 11-25 HASPATH Equality
• 11-26 HASPATH with Other Operators
• 11-27 Using EXTRACT to Scope the Results of a CONTAINS Query
• 11-28 Using EXTRACT and ora:contains to Project the Result of a CONTAINS Query
• 11-29 Simple CONTEXT Index on Table PURCHASE_ORDERS
• 11-30 Simple CONTEXT Index on Table PURCHASE_ORDERS with Path Section Group
• 11-31 Simple CONTEXT Index on Table PURCHASE_ORDERS_xmltype
• 11-32 Simple CONTEXT Index on XMLType Table
• 11-33 CONTAINS Query on XMLType Table
• 11-34 CONTAINS: Default Case Matching
• 11-35 Create a Preference for Mixed Case
• 11-36 CONTEXT Index on PURCHASE_ORDERS Table, Mixed Case
• 11-37 CONTAINS: Mixed (Exact) Case Matching
• 11-38 Simple CONTEXT Index on purchase_orders Table with Path Section Group
• 11-39 ora:contains with an Arbitrarily Complex Text Query
• 11-40 ora:contains in EXISTSNODE and EXTRACT
• 11-41 Create a Policy to Use with ora:contains
• 11-42 Query on a Common Word with ora:contains
• 11-43 Query on a Common Word with ora:contains and Policy my_nostopwords_policy
• 11-44 ora:contains, Default Case-Sensitivity
• 11-45 Create a Preference for Mixed Case
• 11-46 Create a Policy with Mixed Case (Case-Insensitive)
• 11-47 ora:contains, Case-Sensitive (1)
• 11-48 ora:contains, Case-Sensitive (2)
• 11-49 ora:contains in EXISTSNODE, Large Table
• 11-50 EXPLAIN PLAN: EXISTSNODE
• 11-51 B-tree Index on ID
• 11-52 ora:contains in EXISTSNODE, Mixed Query
• 11-53 EXPLAIN PLAN: EXISTSNODE
• 11-54 ora:contains in EXISTSNODE
• 11-55 Purchase Order XML Document, po001.xml
• 11-56 CREATE TABLE purchase_orders
• 11-57 CREATE TABLE purchase_orders_xmltype
• 11-58 CREATE TABLE purchase_orders_xmltype_table
• 11-59 Purchase-Order XML Schema for Full-Text Search Examples
• 12-1 Creating and Manipulating a DOM Document
• 12-2 Creating an Element Node and Obtaining Information About It
• 12-3 Creating a User-Defined Subtype of SYS.util_BinaryOutputStream()
• 12-4 Retrieving Node Value with a User-Defined Stream
• 12-5 Get-Pull of Binary Data
• 12-6 Get-Pull of Character Data
• 12-7 Set-Pull of Binary Data
• 12-8 Set-Push of Binary Data
• 12-9 Parsing an XML Document
• 12-10 Transforming an XML Document Using an XSL Style Sheet
• 13-1 Inserting Data with Specified Columns
• 13-2 Updating Data With Key Columns
• 13-3 DBMS_XMLSTORE.DELETEXML Example
• 14-1 XMLType Java: Using JDBC to Query an XMLType Table
• 14-2 XMLType Java: Selecting XMLType Data
• 14-3 XMLType Java: Directly Returning XMLType Data
• 14-4 XMLType Java: Returning XMLType Data
• 14-5 XMLType Java: Updating, Inserting, or Deleting XMLType Data
• 14-6 XMLType Java: Getting Metadata on XMLType
• 14-7 XMLType Java: Updating an Element in an XMLType Column
• 14-8 Manipulating an XMLType Column
• 14-9 Loading a Large XML Document
• 14-10 Creating a DOM Object with the Java DOM API
• 14-11 Using the Java DOM API With Binary XML
• 15-1 Using OCIXmlDbInitXmlCtx() and OCIXmlDbFreeXmlCtx()
• 15-2 Using the C API for XML With Binary XML
• 15-3 Using the Oracle XML DB Pull Parser
• 15-4 Using the DOM to Count Ordered Parts
• 16-1 Retrieve XMLType Data to .NET
• 17-1 XMLELEMENT: Formatting a Date
• 17-2 XMLELEMENT: Generating an Element for Each Employee
• 17-3 XMLELEMENT: Generating Nested XML
• 17-4 XMLELEMENT: Generating Employee Elements with ID and Name Attributes
• 17-5 XMLELEMENT: Using Namespaces to Create a Schema-Based XML Document
• 17-6 XMLELEMENT: Generating an Element from a User-Defined Data-Type Instance
• 17-7 XMLFOREST: Generating Elements with Attribute and Child Elements
• 17-8 XMLFOREST: Generating an Element from a User-Defined Data-Type Instance
• 17-9 XMLSEQUENCE Returns Only Top-Level Element Nodes
• 17-10 XMLSEQUENCE: Generating One XML Document from Another
• 17-11 XMLSEQUENCE: Generate a Document for Each Row of a Cursor
• 17-12 XMLSEQUENCE: Un-Nesting Collections in XML Documents into SQL Rows
• 17-13 XMLCONCAT: Concatenating XMLType Instances from a Sequence
• 17-14 XMLCONCAT: Concatenating XML Elements
• 17-15 XMLAGG: Generating Department Elements with a List of Employee Elements
• 17-16 XMLAGG: Generating Nested Elements
• 17-17 Using XMLPI
• 17-18 Using XMLCOMMENT
• 17-19 Using XMLRoot
• 17-20 Using XMLSERIALIZE
• 17-21 Using XMLPARSE
• 17-22 XMLCOLATTVAL: Generating Elements with Attribute and Child Elements
• 17-23 Using XMLCDATA
• 17-24 DBMS_XMLGEN: Generating Simple XML
• 17-25 DBMS_XMLGEN: Generating Simple XML with Pagination (Fetch)
• 17-26 DBMS_XMLGEN: Generating Nested XML With Object Types
• 17-27 DBMS_XMLGEN: Generating Nested XML With User-Defined Data-Type Instances
• 17-28 DBMS_XMLGEN: Generating an XML Purchase Order
• 17-29 DBMS_XMLGEN: Generating a New Context Handle from a REF Cursor
• 17-30 DBMS_XMLGEN: Specifying NULL Handling
• 17-31 DBMS_XMLGEN: Generating Recursive XML with a Hierarchical Query
• 17-32 DBMS_XMLGEN: Binding Query Variables with Method setBindValue
• 17-33 Using SYS_XMLGEN to Create XML
• 17-34 SYS_XMLGEN: Generating an XML Element from a Database Column
• 17-35 SYS_XMLGEN: Converting a Scalar Value to XML Element Contents
• 17-36 SYS_XMLGEN: Default Element Name ROW
• 17-37 Overriding the Default Element Name: Using SYS_XMLGEN with XMLFormat
• 17-38 SYS_XMLGEN: Converting a User-Defined Data-Type Instance to XML
• 17-39 SYS_XMLGEN: Converting an XMLType Instance
• 17-40 Using SYS_XMLGEN with Object Views
• 17-41 Using XSQL Servlet <xsql:include-xml> with Nested XMLAgg Functions
• 17-42 Using XSQL Servlet <xsql:include-xml> with XMLElement and XMLAgg
• 17-43 Using XMLAGG ORDER BY Clause
• 17-44 Returning a Rowset using XMLTABLE
• 18-1 Creating Resources for Examples
• 18-2 XMLQuery Applied to a Sequence of Items of Different Types
• 18-3 FLOWR Expression Using For, Let, Order By, Where, and Return
• 18-4 FLOWR Expression Using Built-In Functions
• 18-5 Using ora:view to Query Relational Tables as XML Views
• 18-6 Using ora:view in a Nested FLWOR Query
• 18-7 Using ora:view with XMLTable to Query a Relational Table as XML
• 18-8 Using XMLQuery with PASSING Clause, to Query an XMLType Column
• 18-9 Using XMLTable with XML Schema-Based Data
• 18-10 Using XMLQuery with Schema-Based Data
• 18-11 Using XMLTable with PASSING and COLUMNS Clauses
• 18-12 Using XMLTable to Decompose XML Collection Elements into Relational Data
• 18-13 Using XMLQuery with a Namespace Declaration
• 18-14 Using XMLTable with the XMLNAMESPACES Clause
• 18-15 Optimization of XMLQuery with ora:view
• 18-16 Optimization of XMLTable with ora:view
• 18-17 Optimization of XMLQuery with Schema-Based XMLType Data
• 18-18 Optimization of XMLTable with Schema-Based XMLType Data
• 18-19 Static Type-Checking of XQuery Expressions: ora:view
• 18-20 Static Type-Checking of XQuery Expressions: Schema-Based XML
• 18-21 Using the SQL*Plus XQUERY Command
• 18-22 Using XQuery with PL/SQL
• 18-23 Using XQuery with JDBC
• 18-24 Using XQuery with ODP.NET and C#
• 19-1 Creating an XMLType View Using XMLELEMENT
• 19-2 Creating an XMLType View Using Object Types and SYS_XMLGEN
• 19-3 Registering XML Schema emp_simple.xsd
• 19-4 Creating an XMLType View Using SQL/XML Functions
• 19-5 Querying an XMLType View
• 19-6 Using Namespace Prefixes in XMLType Views
• 19-7 Using SQL/XML Generation Functions in Schema-Based XMLType Views
• 19-8 Creating Object Types for Schema-Based XMLType Views
• 19-9 Generating an XML Schema with DBMS_XMLSCHEMA.GENERATESCHEMA
• 19-10 Registering XML Schema emp_complex.xsd
• 19-11 Creating an XMLType View
• 19-12 Creating an Object View and an XMLType View on the Object View
• 19-13 Creating Object Types
• 19-14 Registering XML Schema dept_complex.xsd
• 19-15 Creating XMLType Views on Relational Tables
• 19-16 Creating XMLType Views Using SQL/XML Functions
• 19-17 Creating an XMLType View by Restricting Rows From an XMLType Table
• 19-18 Creating an XMLType View by Transforming an XMLType Table
• 19-19 Identifying When a View is Implicitly Updatable
• 19-20 Non-Schema-Based Views Constructed Using SQL/XML
• 19-21 XML-Schema-Based Views Constructed With SQL/XML
• 19-22 Non-Schema-Based Views Constructed Using SYS_XMLGEN
• 19-23 Non-Schema-Based Views Constructed Using SYS_XMLGEN on an Object View
• 19-24 XML-Schema-Based Views Constructed Using Object Types
• 19-25 Generating XML Schema-Based XML Without Creating Views
• 20-1 Using HTTPURIType Method getContentType()
• 20-2 Creating and Querying a URI Column
• 20-3 Using Different Kinds of URI, Created in Different Ways
• 20-4 Using an XDBUri to Access a Repository Resource by URI
• 20-5 Using Method getXML() with EXTRACTVALUE
• 20-6 Using a DBUri to Target a Complete Table
• 20-7 Using a DBUri to Target a Particular Row in a Table
• 20-8 Using a DBUri to Target a Specific Column
• 20-9 Using a DBUri to Target an Object Column with Specific Attribute Values
• 20-10 Using a DBUri to Retrieve Only the Text Value of a Node
• 20-11 Using a DBUri to Target a Collection
• 20-12 URIFACTORY: Registering the ECOM Protocol
• 20-13 SYS_DBURIGEN: Generating a DBUri that Targets a Column
• 20-14 Passing Columns With Single Arguments to SYS_DBURIGEN
• 20-15 Inserting Database References Using SYS_DBURIGEN
• 20-16 Returning a Portion of the Results By Creating a View and Using SYS_DBURIGEN
• 20-17 Using SYS_DBURIGEN in the RETURNING Clause to Retrieve a URL
• 20-18 Using a URL to Override the MIME Type
• 20-19 Changing the Installation Location of DBUriServlet
• 20-20 Restricting Servlet Access to a Database Role
• 20-21 Registering a Handler for a DBUri Prefix
• 21-1 Querying PATH_VIEW to Determine Link Type
• 21-2 Obtaining the OID Path of a Resource
• 21-3 Creating a Weak Link Using an OID Path
• 22-1 Resource Configuration File
• 22-2 applicationData Element
• 23-1 XInclude Used in a Book Document to Include Parts and Chapters
• 23-2 Using XDBURIType to Expand Document Inclusions
• 23-3 Querying Document Links Mapped From XLink Links
• 23-4 Querying Document Links Mapped From XInclude Links
• 23-5 Mapping XInclude Links to Hard Document Links, With OID Retrieval
• 23-6 Mapping XLInk Links to Weak Links, With Named-Path Retrieval
• 23-7 Configuring XInclude Document Decomposition
• 23-8 Repository Document, Showing Generated xi:include Elements
• 24-1 Using DBMS_XDB_VERSION.GetResourceByResId To Retrieve a Resource
• 24-2 Using DBMS_XDB_VERSION.makeVersioned To Create a VCR
• 24-3 Retrieving the Resource ID of the New Version After Check-In
• 24-4 Oracle XML DB: Creating and Updating a Version-Controlled Resource (VCR)
• 24-5 VCR Check-Out
• 24-6 VCR Check-In
• 24-7 VCR unCheckOut
• 25-1 Determining Paths Under a Path: Relative
• 25-2 Determining Paths Under a Path: Absolute
• 25-3 Determining Paths Not Under a Path
• 25-4 Determining Paths Using Multiple Correlations
• 25-5 Relative Path Names for Three Levels of Resources
• 25-6 Extracting Resource Metadata using UNDER_PATH
• 25-7 Using Functions PATH and DEPTH with PATH_VIEW
• 25-8 Extracting Link and Resource Information from PATH_VIEW
• 25-9 All Paths to a Certain Depth Under a Path
• 25-10 Using EQUALS_PATH to Locate a Path
• 25-11 Retrieve RESID of a Given Resource
• 25-12 Obtaining the Path Name of a Resource from its RESID
• 25-13 Folders Under a Given Path
• 25-14 Joining RESOURCE_VIEW with an XMLType Table
• 25-15 Deleting Resources
• 25-16 Deleting Links to Resources
• 25-17 Deleting a Nonempty Folder
• 25-18 Updating a Resource
• 25-19 Updating a Path in the PATH_VIEW
• 25-20 Updating Resources Based on Attributes
• 25-21 Finding Resources Inside a Folder
• 25-22 Copying Resources
• 25-23 Find All Resources Containing "Paper"
• 25-24 Find All Resources Containing "Paper" that are Under a Specified Path
• 26-1 Using DBMS_XDB to Manage Resources
• 26-2 Using Procedure DBMS_XDB.getACLDocument
• 26-3 Using Procedure DBMS_XDB.setACL
• 26-4 Using Function DBMS_XDB.changePrivileges
• 26-5 Using Function DBMS_XDB.getPrivileges
• 26-6 Using Function DBMS_XDB.cfg_get
• 26-7 Using Procedure DBMS_XDB.cfg_update
• 27-1 Simple Access Control Entry (ACE) that Grants a System Privilege
• 27-2 Simple Access Control List (ACL) that Grants a System Privilege
• 27-3 Simple Security Class
• 27-4 Element extends-from
• 27-5 Element constrained-with
• 27-6 Complementing a Set of Principals with Element invert
• 27-7 ACE with Start and End Dates
• 27-8 Creating an ACL Using DBMS_XDB.createResource
• 27-9 Retrieving an ACL Document, Given its Repository Path
• 27-10 Setting the ACL of a Resource
• 27-11 Deleting an ACL
• 27-12 Updating (Replacing) an Access Control List
• 27-13 Appending ACEs to an Access Control List
• 27-14 Deleting an ACE from an Access Control List
• 27-15 Retrieving the ACL Document for a Resource
• 27-16 Retrieving Privileges Granted to the Current User for a Particular Resource
• 27-17 Checking If a User Has a Certain Privileges on a Resource
• 27-18 Checking User Privileges using ACLCheckPrivileges
• 27-19 Retrieving the Path of the ACL that Protects a Given Resource
• 27-20 Retrieving the Paths of All Resources Protected by a Given ACL
• 27-21 ACL Referencing an LDAP User
• 27-22 ACL Referencing an LDAP Group
• 28-1 Navigating ASM Folders
• 28-2 Transferring ASM Files Between Databases with FTP proxy Method
• 28-3 Modifying the Default Timeout Value of an FTP Session
• 29-1 Register an XML Schema for Technical Photo Information
• 29-2 Register an XML Schema for Photo Categorization
• 29-3 Add Metadata to a Resource - Technical Photo Information
• 29-4 Add Metadata to a Resource - Photo Content Categories
• 29-5 Delete Specific Metadata from a Resource
• 29-6 Add Metadata to a Resource Using DML with RESOURCE_VIEW
• 29-7 Add Metadata with WebDAV PROPPATCH
• 29-8 Query XML Schema-Based Resource Metadata
• 29-9 Add Non-Schema-Based Metadata to a Resource
• 30-1 Resource Configuration File for Java Event Listeners With Preconditions
• 30-2 Resource Configuration File for PL/SQL Event Listeners With No Preconditions
• 30-3 PL/SQL Code Implementing Event Listeners
• 30-4 Java Code Implementing Event Listeners
• 30-5 Invoking Event Handlers
• 31-1 JCR Node Representation of MyFolder
• 31-2 Code Fragment Showing How to Get a Repository Object
• 31-3 Using Oracle XML DB Content Connector to Upload a File
• 31-4 XML Document With XML Schema-Based Content
• 31-5 XML Schema
• 31-6 JCR Representation of XML Content Not Registered for JCR Use
• 31-7 JCR Representation of XML Content Registered for JCR Use
• 31-8 Registering an XML Schema for Use with Oracle XML DB
• 31-9 Registering an XML Schema for Use with JCR
• 32-1 Writing an Oracle XML DB Servlet
• 33-1 Adding a Web Services Configuration Servlet
• 33-2 Verifying Addition of Web Services Configuration Servlet
• 33-3 XML Schema for Database Queries To Be Processed by Web Service
• 33-4 Input XML Document for SQL Query Using Query Web Service
• 33-5 Output XML Document for SQL Query Using Query Web Service
• 33-6 Definition of PL/SQL Function Used for Web-Service Access
• 33-7 WSDL Document Corresponding to a Stored PL/SQL Function
• 33-8 Input XML Document for PL/SQL Query Using Web Service
• 33-9 Output XML Document for PL/SQL Query Using Web Service
• 34-1 Oracle XML DB Configuration File
• 34-2 Updating the Configuration File Using CFG_UPDATE and CFG_GET
• 35-1 Loading Very Large XML Documents Into Oracle Database Using SQL*Loader
• 36-1 Exporting XMLType Data in TABLE Mode
• 36-2 Importing XMLType Data in TABLE Mode
• 36-3 Creating Table po2
• 36-4 Exporting XMLType Data in SCHEMA Mode
• 36-5 Importing XMLType Data in SCHEMA Mode
• 36-6 Importing XMLType Data in SCHEMA Mode, Remapping Schema
• 37-1 XMLType and AQ: Creating a Table and Queue, and Transforming Messages
• 37-2 XMLType and AQ: Dequeuing Messages
• A-1 Annotated Purchase-Order XML Schema, purchaseOrder.xsd
• A-2 Revised Purchase-Order XML Schema
• A-3 Inserting XML Content into an XMLType Table Using C
• A-4 Using OCIXmlDbInitXmlCtx() and OCIXmlDbFreeXmlCtx()