List of Examples

• 3-1 Creating a Table with an XMLType Column
• 3-2 Creating a Table of XMLType
• 3-3 Creating a Virtual Column for an XML Attribute in an XMLType Table
• 3-4 Creating a Virtual Column for an XML Attribute in an XMLType Column
• 3-5 Partitioning a Relational Table That Has an XMLType Column
• 3-6 Partitioning an XMLType Table
• 3-7 Error From Attempting to Insert an Incorrect XML Document
• 3-8 Constraining a Binary XML Table Using a Virtual Column
• 3-9 Constraining a Binary XML Column Using a Virtual Column: Uniqueness
• 3-10 Constraining a Binary XML Column Using a Virtual Column: Foreign Key
• 3-11 Enforcing Database Integrity When Loading XML Using FTP
• 3-12 Creating a Database Directory
• 3-13 Inserting XML Content into an XMLType Table
• 3-14 Inserting Content into an XMLType Table Using Java
• 3-15 Inserting Content into an XMLType Table Using C
• 3-16 Inserting XML Content into the Repository Using CREATERESOURCE
• 3-17 PurchaseOrder XML Instance Document
• 3-18 Retrieving an Entire XML Document Using OBJECT_VALUE
• 3-19 Accessing XML Fragments Using XMLQUERY
• 3-20 Accessing a Text Node Value Using XMLCAST and XMLQuery
• 3-21 Searching XML Content Using XMLExists, XMLCast, and XMLQuery
• 3-22 Joining Data from an XMLType Table and a Relational Table
• 3-23 Accessing Description Nodes Using XMLTABLE
• 3-24 Counting the Number of Elements in a Collection Using XMLTABLE
• 3-25 Counting the Number of Child Elements in an Element Using XMLTABLE
• 3-26 Updating a Text Node
• 3-27 Replacing an Entire Element Using XQuery Update
• 3-28 Changing Text Node Values Using XQuery Update
• 3-29 Generating XML Data Using SQL/XML Functions
• 3-30 Creating XMLType Views Over Conventional Relational Tables
• 3-31 Querying XMLType Views
• 3-32 Generating XML Data from a Relational Table Using DBURIType and getXML()
• 3-33 Restricting Rows Using an XPath Predicate
• 3-34 Restricting Rows and Columns Using an XPath Predicate
• 4-1 Chaining XMLTable Calls
• 4-2 Finding a Node Using SQL/XML Function XMLExists
• 4-3 Extracting the Scalar Value of an XML Fragment Using XMLCAST
• 4-4 Static Type-Checking of XQuery Expressions: oradb URI scheme
• 4-5 Static Type-Checking of XQuery Expressions: XML Schema-Based Data
• 5-1 Creating Resources for Examples
• 5-2 XMLQuery Applied to a Sequence of Items of Different Types
• 5-3 FLOWR Expression Using for, let, order by, where, and return
• 5-4 FLOWR Expression Using Built-In Functions
• 5-5 Querying Relational Data as XML Using XMLQuery
• 5-6 Querying Relational Data as XML Using a Nested FLWOR Expression
• 5-7 Querying Relational Data as XML Using XMLTable
• 5-8 Querying an XMLType Column Using XMLQuery PASSING Clause
• 5-9 Using XMLTABLE with XML Schema-Based Data
• 5-10 Using XMLQUERY with XML Schema-Based Data
• 5-11 Using XMLTABLE with PASSING and COLUMNS Clauses
• 5-12 Using XMLTABLE with RETURNING SEQUENCE BY REF
• 5-13 Using Chained XMLTABLE with Access by Reference
• 5-14 Using XMLTABLE to Decompose XML Collection Elements into Relational Data
• 5-15 Using XMLQUERY with a Namespace Declaration
• 5-16 Using XMLTABLE with the XMLNAMESPACES Clause
• 5-17 Querying XMLTYPE Data
• 5-18 Querying Transient XMLTYPE Data Using a PL/SQL Cursor
• 5-19 Extracting XML Data and Inserting It into a Relational Table Using SQL
• 5-20 Extracting XML Data and Inserting It into a Table Using PL/SQL
• 5-21 Searching XML Data Using SQL/XML Functions
• 5-22 Extracting Fragments Using XMLQUERY
• 5-23 Using the SQL*Plus XQUERY Command
• 5-24 Using XQuery with PL/SQL
• 5-25 Using XQuery with JDBC
• 5-26 Using XQuery with ODP.NET and C#
• 5-27 Updating XMLType Data Using SQL UPDATE
• 5-28 Updating XMLTYPE Data Using SQL UPDATE and XQuery Update
• 5-29 Updating Multiple Text Nodes and Attribute Nodes
• 5-30 Updating Selected Nodes within a Collection
• 5-31 Incorrectly Updating a Node That Occurs Multiple Times in a Collection
• 5-32 Correctly Updating a Node That Occurs Multiple Times in a Collection
• 5-33 NULL Updates – Element and Attribute
• 5-34 NULL Updates – Text Node
• 5-35 Inserting an Element into a Collection
• 5-36 Inserting an Element that Uses a Namespace
• 5-37 Inserting an Element Before an Element
• 5-38 Inserting an Element as the Last Child Element
• 5-39 Deleting an Element
• 5-40 Creating a View Using Updated XML Data
• 5-41 Optimization of XMLQuery over Relational Data
• 5-42 Optimization of XMLTable over Relational Data
• 5-43 Optimization of XMLQuery with Schema-Based XMLType Data
• 5-44 Optimization of XMLTable with Schema-Based XMLType Data
• 5-45 Unoptimized Repository Query Using fn:doc
• 5-46 Optimized Repository Query Using EQUALS_PATH
• 5-47 Repository Query Using Oracle XQuery Pragma ora:defaultTable
• 6-1 Making Query Data Compatible with Index Data – SQL Cast
• 6-2 Making Query Data Compatible with Index Data – XQuery Cast
• 6-3 Exchange-Partitioning a Table Having an XMLIndex Structured Component
• 6-4 Path Table Contents for Two Purchase Orders
• 6-5 Creating an XMLIndex Index
• 6-6 Obtaining the Name of an XMLIndex Index on a Particular Table
• 6-7 Renaming and Dropping an XMLIndex Index
• 6-8 Naming the Path Table of an XMLIndex Index
• 6-9 Determining the System-Generated Name of an XMLIndex Path Table
• 6-10 Specifying Storage Options When Creating an XMLIndex Index
• 6-11 Dropping an XMLIndex Unstructured Component
• 6-12 Determining the Names of the Secondary Indexes of an XMLIndex Index
• 6-13 Creating a Function-Based Index on Path-Table Column VALUE
• 6-14 Trying to Create a Numeric Index on Path-Table Column VALUE Directly
• 6-15 Creating a Numeric Index on Column VALUE with Procedure createNumberIndex
• 6-16 Creating a Date Index on Column VALUE with Procedure createDateIndex
• 6-17 Creating an Oracle Text CONTEXT Index on Path-Table Column VALUE
• 6-18 Showing All Secondary Indexes on an XMLIndex Path Table
• 6-19 XMLIndex with Only a Structured Component and Using Namespaces
• 6-20 XMLIndex Index: Adding a Structured Component
• 6-21 Using DBMS_XMLINDEX.PROCESS_PENDING To Index XML Data
• 6-22 Dropping an XMLIndex Structured Component
• 6-23 Creating a B-tree Index on an XMLIndex Index Content Table
• 6-24 Checking Whether an XMLIndex Unstructured Component Is Used
• 6-25 Obtaining the Name of an XMLIndex Index from Its Path-Table Name
• 6-26 Extracting Data from an XML Fragment Using XMLIndex
• 6-27 Using a Structured XMLIndex Component for a Query with Two Predicates
• 6-28 Using a Structured XMLIndex Component for a Query with Multilevel Chaining
• 6-29 Turning Off XMLIndex Using Optimizer Hints
• 6-30 XMLIndex Path Subsetting with CREATE INDEX
• 6-31 XMLIndex Path Subsetting with ALTER INDEX
• 6-32 XMLIndex Path Subsetting Using a Namespace Prefix
• 6-33 Creating an XMLIndex Index in Parallel
• 6-34 Using Different PARALLEL Degrees for XMLIndex Internal Objects
• 6-35 Specifying Deferred Synchronization for XMLIndex
• 6-36 Manually Synchronizing an XMLIndex Index Using SYNCINDEX
• 6-37 Automatic Collection of Statistics on XMLIndex Objects
• 6-38 Creating an XML Search Index
• 6-39 XQuery Full Text Query
• 6-40 Execution Plan for XQuery Full Text Query
• 6-41 XQuery Full Text Query with XML Schema-Based Data: Error ORA-18177
• 6-42 Using XQuery Pragma ora:no_schema with XML Schema-Based Data
• 6-43 Full-Text Query with XQuery Pragma ora:use_xmltext_idx
• 6-44 CREATE INDEX Using XMLCAST and XMLQUERY on a Singleton Element
• 6-45 CREATE INDEX Using EXTRACTVALUE on a Singleton Element
• 7-1 XSLT Stylesheet Example: PurchaseOrder.xsl
• 7-2 Registering an XML Schema and Inserting XML Data
• 7-3 Using SQL Function XMLTRANSFORM to Apply an XSL Stylesheet
• 7-4 Using XMLType Method TRANSFORM() with a Transient XSL Stylesheet
• 7-5 Using XMLTRANSFORM to Apply an XSL Stylesheet Retrieved Using XDBURIType
• 7-6 Error When Inserting Incorrect XML Document (Partial Validation)
• 7-7 Forcing Full XML Schema Validation Using a CHECK Constraint
• 7-8 Enforcing Full XML Schema Validation Using a BEFORE INSERT Trigger
• 7-9 Validating XML Using Method ISSCHEMAVALID() in SQL
• 7-10 Validating XML Using Method ISSCHEMAVALID() in PL/SQL
• 7-11 Validating XML Using Method SCHEMAVALIDATE() within Triggers
• 7-12 Checking XML Validity Using XMLISVALID Within CHECK Constraints
• 8-1 XMLELEMENT: Formatting a Date
• 8-2 XMLELEMENT: Generating an Element for Each Employee
• 8-3 XMLELEMENT: Generating Nested XML
• 8-4 XMLELEMENT: Generating Employee Elements with Attributes ID and Name
• 8-5 XMLELEMENT: Characters in Generated XML Data Are Not Escaped
• 8-6 Creating a Schema-Based XML Document Using XMLELEMENT with Namespaces
• 8-7 XMLELEMENT: Generating an Element from a User-Defined Data-Type Instance
• 8-8 XMLFOREST: Generating Elements with Attribute and Child Elements
• 8-9 XMLFOREST: Generating an Element from a User-Defined Data-Type Instance
• 8-10 XMLCONCAT: Concatenating XMLType Instances from a Sequence
• 8-11 XMLCONCAT: Concatenating XML Elements
• 8-12 XMLAGG: Generating a Department Element with Child Employee Elements
• 8-13 XMLAGG: Using GROUP BY to Generate Multiple Department Elements
• 8-14 XMLAGG: Generating Nested Elements
• 8-15 Using SQL/XML Function XMLPI
• 8-16 Using SQL/XML Function XMLCOMMENT
• 8-17 Using SQL/XML Function XMLSERIALIZE
• 8-18 Using SQL/XML Function XMLPARSE
• 8-19 Using Oracle SQL Function XMLRoot
• 8-20 XMLCOLATTVAL: Generating Elements with Attribute and Child Elements
• 8-21 Using Oracle SQL Function XMLCDATA
• 8-22 DBMS_XMLGEN: Generating Simple XML
• 8-23 DBMS_XMLGEN: Generating Simple XML with Pagination (Fetch)
• 8-24 DBMS_XMLGEN: Generating XML Using Object Types
• 8-25 DBMS_XMLGEN: Generating XML Using User-Defined Data-Type Instances
• 8-26 DBMS_XMLGEN: Generating an XML Purchase Order
• 8-27 DBMS_XMLGEN: Generating a New Context Handle from a REF Cursor
• 8-28 DBMS_XMLGEN: Specifying NULL Handling
• 8-29 DBMS_XMLGEN: Generating Recursive XML with a Hierarchical Query
• 8-30 DBMS_XMLGEN: Binding Query Variables Using SETBINDVALUE()
• 8-31 Using XMLAGG ORDER BY Clause
• 8-32 Returning a Rowset Using XMLTABLE
• 9-1 Creating a Relational View of XML Content
• 9-2 Accessing Individual Members of a Collection Using a View
• 9-3 XMLIndex Index that Matches Relational View Columns
• 9-4 XMLTable Expression Returned by PL/SQL Function getSIDXDefFromView
• 9-5 Querying Master Relational View of XML Data
• 9-6 Querying Master and Detail Relational Views of XML Data
• 9-7 Business-Intelligence Query of XML Data Using a View
• 10-1 Creating an XMLType View Using XMLELEMENT
• 10-2 Registering XML Schema emp_simple.xsd
• 10-3 Creating an XMLType View Using SQL/XML Publishing Functions
• 10-4 Querying an XMLType View
• 10-5 Using Namespace Prefixes with SQL/XML Publishing Functions
• 10-6 XML Schema with No Target Namespace
• 10-7 Creating a View for an XML Schema with No Target Namespace
• 10-8 Using SQL/XML Functions in XML Schema-Based XMLType Views
• 10-9 Creating Object Types for Schema-Based XMLType Views
• 10-10 Registering XML Schema emp_complex.xsd
• 10-11 Creating XMLType View emp_xml
• 10-12 Creating an Object View and an XMLType View on the Object View
• 10-13 Creating Object Types
• 10-14 Registering XML Schema dept_complex.xsd
• 10-15 Creating XMLType View dept_xml Using Object Type dept_t
• 10-16 Creating XMLType View dept_xml Using Relational Data Directly
• 10-17 Creating an XMLType View by Restricting Rows from an XMLType Table
• 10-18 Creating an XMLType View by Transforming an XMLType Table
• 10-19 Determining Whether an XMLType View Is Implicitly Updatable
• 11-1 Creating and Manipulating a DOM Document
• 11-2 Creating an Element Node and Obtaining Information About It
• 11-3 Creating a User-Defined Subtype of SYS.util_BinaryOutputStream()
• 11-4 Retrieving Node Value with a User-Defined Stream
• 11-5 Get-Pull of Binary Data
• 11-6 Get-Pull of Character Data
• 11-7 Set-Pull of Binary Data
• 11-8 Set-Push of Binary Data
• 11-9 Parsing an XML Document
• 11-10 Transforming an XML Document Using an XSL Stylesheet
• 12-1 Inserting Data with Specified Columns
• 12-2 Updating Data with Key Columns
• 12-3 DBMS_XMLSTORE.DELETEXML Example
• 13-1 Querying an XMLType Table Using JDBC
• 13-2 Selecting XMLType Data Using getStringVal() and getCLOB()
• 13-3 Returning XMLType Data Using getObject()
• 13-4 Returning XMLType Data Using an Output Parameter
• 13-5 Updating XMLType Data Using SQL UPDATE with Constructor XMLType
• 13-6 Updating XMLType Data Using SQL UPDATE with setObject()
• 13-7 Retrieving Metadata about XMLType Data Using JDBC
• 13-8 Updating an Element in an XMLType Column Using JDBC
• 13-9 Updated Purchase-Order Document
• 13-10 Manipulating an XMLType Column Using JDBC
• 13-11 Java Method insertXML()
• 13-12 Java Method getCLOB()
• 13-13 Policy File Granting Permissions for Java DOM API
• 13-14 Creating a DOM Object with the Java DOM API
• 13-15 Using the Java DOM API with Binary XML
• 14-1 Using OCIXMLDBINITXMLCTX() and OCIXMLDBFREEXMLCTX()
• 14-2 Using the C API for XML with Binary XML
• 14-3 Using the Oracle XML DB Pull Parser
• 14-4 Using the DOM to Count Ordered Parts
• 15-1 Retrieve XMLType Data to .NET
• 17-1 Registering an XML Schema Using DBMS_XMLSCHEMA.REGISTERSCHEMA
• 17-2 Objects Created During XML Schema Registration
• 17-3 Registering a Local XML Schema
• 17-4 Registering a Global XML Schema
• 17-5 Deleting an XML Schema with DBMS_XMLSCHEMA.DELETESCHEMA
• 17-6 Data Dictionary Table for Registered Schemas
• 17-7 Creating XML Schema-Based XMLType Tables and Columns
• 17-8 Creating an Object-Relational XMLType Table with Default Storage
• 17-9 Specifying Object-Relational Storage Options for XMLType Tables and Columns
• 17-10 Using STORE ALL VARRAYS AS
• 18-1 SQL Object Types for Storing XMLType Tables
• 18-2 Default Table for Global Element PurchaseOrder
• 18-3 Using Common Schema Annotations
• 18-4 Registering an Annotated XML Schema
• 18-5 Using DBMS_XMLSCHEMA_ANNOTATE
• 18-6 Querying View USER_XML_SCHEMAS for a Registered XML Schema
• 18-7 Querying Metadata from a Registered XML Schema
• 18-8 Mapping XML Schema Data Types to SQL Data Types Using Attribute SQLType
• 18-9 XML Schema Inheritance: complexContent as an Extension of complexTypes
• 18-10 Inheritance in XML Schema: Restrictions in complexTypes
• 18-11 XML Schema complexType: Mapping complexType to simpleContent
• 18-12 XML Schema: Mapping complexType to any/anyAttribute
• 18-13 Creating an XMLType Table that Conforms to an XML Schema
• 18-14 Creating an XMLType Table for Nested Collections
• 18-15 Using DESCRIBE with an XML Schema-Based XMLType Table
• 18-16 Specifying Partitioning Information During XML Schema Registration
• 18-17 Specifying Partitioning Information During Table Creation
• 18-18 Integrity Constraints and Triggers for an XMLType Table Stored Object-Relationally
• 18-19 Adding a Unique Constraint to the Parent Element of an Attribute
• 18-20 Setting SQLInline to False for Out-Of-Line Storage
• 18-21 Generated XMLType Tables and Types
• 18-22 Querying an Out-Of-Line Table
• 18-23 Storing a Collection Out of Line
• 18-24 Generated Out-Of-Line Collection Type
• 18-25 Renaming an Intermediate Table of REF Values
• 18-26 XPath Rewrite for an Out-Of-Line Collection
• 18-27 XPath Rewrite for an Out-Of-Line Collection, with Index on REFs
• 18-28 An XML Schema with Circular Dependency
• 18-29 XML Schema: Cycling Between complexTypes
• 18-30 XML Schema: Cycling Between complexTypes, Self-Reference
• 18-31 An XML Schema that Includes a Non-Existent XML Schema
• 18-32 Using the FORCE Option to Register XML Schema xm40.xsd
• 18-33 Trying to Create a Table Using a Cyclic XML Schema
• 18-34 Using the FORCE Option to Register XML Schema xm40a.xsd
• 18-35 Recursive XML Schema
• 18-36 Out-of-line Table
• 18-37 Invalid Default Table Sharing
• 18-38 Oracle XML DB XML Schema: Mapping complexType XML Fragments to LOBs
• 19-1 XPath Rewrite
• 19-2 XPath Rewrite for an Out-Of-Line Table
• 19-3 Using an Index with an Out-Of-Line Table
• 19-4 Execution Plan Generated When XPath Rewrite Does Not Occur
• 19-5 Analyzing an Execution Plan to Determine a Column to Index
• 19-6 Using DBMS_XMLSTORAGE_MANAGE.XPATH2TABCOLMAPPING
• 19-7 Creating an Index on a Column Targeted by a Predicate
• 19-8 Creating a Function-Based Index for a Column Targeted by a Predicate
• 19-9 Execution Plan Showing that Index Is Picked Up
• 19-10 Creating a Function-Based Index for a Column Targeted by a Predicate
• 19-11 Execution Plan for a Selection of Collection Elements
• 19-12 Creating an Index for Direct Access to an Ordered Collection Table
• 20-1 Revised Purchase-Order XML Schema
• 20-2 evolvePurchaseOrder.xsl: XSLT Stylesheet to Update Instance Documents
• 20-3 Loading Revised XML Schema and XSLT Stylesheet
• 20-4 Updating an XML Schema Using DBMS_XMLSCHEMA.COPYEVOLVE
• 20-5 Splitting a Complex Type into Two Complex Types
• 20-6 diffXML Parameter Document
• 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
• 21-4 Accessing a Text Document in the Repository Using XDBURITYPE
• 21-5 Accessing Resource Content Using RESOURCE_VIEW
• 21-6 Accessing XML Documents Using Resource and Namespace Prefixes
• 21-7 Querying Repository Resource Data Using SQL Function REF and Element XMLRef
• 21-8 Selecting XML Document Fragments Based on Metadata, Path, and Content
• 21-9 Updating a Document Using UPDATE and XQuery Update on the Resource
• 21-10 Updating a Node Using UPDATE and XQuery Update
• 21-11 Updating XML Schema-Based Documents in the Repository
• 21-12 Accessing Resources Using EQUALS_PATH and RESOURCE_VIEW
• 21-13 Determining the Path to XSLT Stylesheets Stored in the Repository
• 21-14 Counting Resources Under a Path
• 21-15 Listing the Folder Contents in a Path
• 21-16 Listing the Links Contained in a Folder
• 21-17 Finding Paths to Resources that Contain Purchase-Order XML Documents
• 21-18 Execution Plan Output for a Folder-Restricted Query
• 22-1 Resource Configuration File
• 22-2 applicationData Element
• 23-1 XInclude Used in a Book Document to Include Parts and Chapters
• 23-2 Expanding Document Inclusions Using XDBURIType
• 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 Determining Paths Under a Path: Relative
• 24-2 Determining Paths Under a Path: Absolute
• 24-3 Determining Paths Not Under a Path
• 24-4 Determining Paths Using Multiple Correlations
• 24-5 Relative Path Names for Three Levels of Resources
• 24-6 Extracting Resource Metadata Using UNDER_PATH
• 24-7 Using Functions PATH and DEPTH with PATH_VIEW
• 24-8 Extracting Link and Resource Information from PATH_VIEW
• 24-9 All Repository Paths to a Certain Depth Under a Path
• 24-10 Locating a Repository Path Using EQUALS_PATH
• 24-11 Retrieve RESID of a Given Resource
• 24-12 Obtaining the Path Name of a Resource from its RESID
• 24-13 Folders Under a Given Path
• 24-14 Joining RESOURCE_VIEW with an XMLType Table
• 24-15 Deleting Resources
• 24-16 Deleting Links to Resources
• 24-17 Deleting a Nonempty Folder
• 24-18 Updating a Resource
• 24-19 Updating a Path in the PATH_VIEW
• 24-20 Updating Resources Based on Attributes
• 24-21 Finding Resources Inside a Folder
• 24-22 Copying Resources
• 24-23 Find All Resources Containing "Paper"
• 24-24 Find All Resources Containing "Paper" that are Under a Specified Path
• 25-1 Creating a Repository Resource
• 25-2 Creating a Version-Controlled Resource
• 25-3 Retrieving Resource Content by Referencing the Resource ID
• 25-4 Checking Out a Version-Controlled Resource
• 25-5 Updating Resource Content
• 25-6 Checking In a Version-Controlled Resource
• 25-7 Retrieving Resource Version Content Using XDBURITYPE and CREATEOIDPATH
• 25-8 Retrieving Resource Version Content Using GETCONTENTSCLOBBYRESID
• 25-9 Retrieving Resource Version Metadata Using GETRESOURCEBYRESID
• 25-10 Canceling a Check-Out Using UNCHECKOUT
• 26-1 Managing Resources Using DBMS_XDB_REPOS
• 26-2 Using DBMS_XDB_REPOS.GETACLDOCUMENT
• 26-3 Using DBMS_XDB_REPOS.SETACL
• 26-4 Using DBMS_XDB_REPOS.CHANGEPRIVILEGES
• 26-5 Using DBMS_XDB_REPOS.GETPRIVILEGES
• 26-6 Using DBMS_XDB_CONFIG.CFG_GET
• 26-7 Using DBMS_XDB_CONFIG.CFG_UPDATE
• 27-1 Simple Access Control Entry (ACE) that Grants a Privilege
• 27-2 Simple Access Control List (ACL) that Grants a Privilege
• 27-3 Complementing a Set of Principals with Element invert
• 27-4 Creating an ACL Using CREATERESOURCE
• 27-5 Retrieving an ACL Document, Given its Repository Path
• 27-6 Setting the ACL of a Resource
• 27-7 Deleting an ACL
• 27-8 Updating (Replacing) an Access Control List
• 27-9 Appending ACEs to an Access Control List
• 27-10 Deleting an ACE from an Access Control List
• 27-11 Retrieving the ACL Document for a Resource
• 27-12 Retrieving Privileges Granted to the Current User for a Particular Resource
• 27-13 Checking If a User Has a Certain Privileges on a Resource
• 27-14 Checking User Privileges Using ACLCheckPrivileges
• 27-15 Retrieving the Path of the ACL that Protects a Given Resource
• 27-16 Retrieving the Paths of All Resources Protected by a Given ACL
• 27-17 ACL Referencing an LDAP User
• 27-18 ACL Referencing an LDAP Group
• 28-1 Listener Status with FTP and HTTP(S) Protocol Support Enabled
• 28-2 Uploading Content to the Repository Using FTP
• 28-3 Navigating Oracle ASM Folders
• 28-4 Transferring Oracle ASM Files Between Databases with FTP proxy Method
• 28-5 FTP Connection Using IPv6
• 28-6 Modifying the Default Timeout Value of an FTP Session
• 29-1 Registering an XML Schema for Technical Photo Information
• 29-2 Registering 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 Adding Metadata to a Resource Using DML with RESOURCE_VIEW
• 29-7 Adding Metadata Using 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 Uploading a File Using Oracle XML DB Content Connector
• 31-4 Uploading a File Using the Command Line
• 31-5 XML Document with XML Schema-Based Content
• 31-6 XML Schema
• 31-7 JCR Representation of XML Content Not Registered for JCR Use
• 31-8 JCR Representation of XML Content Registered for JCR Use
• 31-9 Registering an XML Schema for Use with Oracle XML DB
• 31-10 Registering an XML Schema for Use with JCR
• 32-1 An Oracle XML DB Servlet
• 32-2 Registering and Mapping an Oracle XML DB Servlet
• 33-1 Using HTTPURIType PL/SQL Method GETCONTENTTYPE()
• 33-2 Creating and Querying a URI Column
• 33-3 Using Different Kinds of URI, Created in Different Ways
• 33-4 Access a Repository Resource by URI Using an XDBUri
• 33-5 Using PL/SQL Method GETXML() with XMLCAST and XMLQUERY
• 33-6 Targeting a Complete Table Using a DBUri
• 33-7 Targeting a Particular Row in a Table Using a DBUri
• 33-8 Targeting a Specific Column Using a DBUri
• 33-9 Targeting an Object Column with Specific Attribute Values Using a DBUri
• 33-10 Retrieve Only the Text Value of a Node Using a DBUri
• 33-11 Targeting a Collection Using a DBUri
• 33-12 URIFACTORY: Registering the ECOM Protocol
• 33-13 SYS_DBURIGEN: Generating a DBUri that Targets a Column
• 33-14 Passing Columns with Single Arguments to SYS_DBURIGEN
• 33-15 Inserting Database References Using SYS_DBURIGEN
• 33-16 Creating the Travel Story Table
• 33-17 A Function that Returns the First 20 Characters
• 33-18 Creating a Travel View for Use with SYS_DBURIGEN
• 33-19 Retrieving a URL Using SYS_DBURIGEN in RETURNING Clause
• 33-20 Changing the Installation Location of DBUriServlet
• 33-21 Restricting Servlet Access to a Database Role
• 33-22 Registering a Handler for a DBUri Prefix
• 34-1 Adding a Web Services Configuration Servlet
• 34-2 Verifying Addition of Web Services Configuration Servlet
• 34-3 XML Schema for Database Queries To Be Processed by Web Service
• 34-4 Input XML Document for SQL Query Using Query Web Service
• 34-5 Output XML Document for SQL Query Using Query Web Service
• 34-6 Definition of PL/SQL Function Used for Web-Service Access
• 34-7 WSDL Document Corresponding to a Stored PL/SQL Function
• 34-8 Input XML Document for PL/SQL Query Using Web Service
• 34-9 Output XML Document for PL/SQL Query Using Web Service
• 35-1 Oracle XML DB Configuration File
• 35-2 Updating the Configuration File Using CFG_UPDATE and CFG_GET
• 36-1 Data File filelist.dat: List of XML Files to Load
• 36-2 Control File load_datra.ctl, for Loading Purchase-Order XML Documents
• 36-3 Loading XML Data Using Shell Command sqlldr
• 37-1 Exporting XMLType Data in TABLE Mode
• 37-2 Importing XMLType Data in TABLE Mode
• 37-3 Creating Table po2
• 37-4 Exporting XMLType Data in SCHEMA Mode
• 37-5 Importing XMLType Data in SCHEMA Mode
• 37-6 Importing XMLType Data in SCHEMA Mode, Remapping Schema
• 38-1 Creating a Queue Table and Queue
• 38-2 Creating a Transformation to Convert Message Data to XML
• 38-3 Applying a Transformation before Sending Messages Overseas
• 38-4 XMLType and AQ: Dequeuing Messages
• 39-1 A JSON Object (Representation of a JavaScript Object Literal)
• 39-2 Simple SQL Query of JSON Data
• 39-3 Using IS JSON in a Check Constraint to Ensure JSON Data is Well-Formed
• 39-4 Inserting Data into a Relational Table with a JSON Column
• 39-5 Using IS JSON in a Check Constraint to Ensure JSON Data is Strictly Well-Formed (Standard)
• 39-6 JSON_EXISTS Expressed Using JSON_TABLE
• 39-7 JSON_VALUE: Two Ways to Return a JSON Boolean Value in SQL
• 39-8 JSON_VALUE Expressed Using JSON_TABLE
• 39-9 Selecting JSON Values Using JSON_QUERY
• 39-10 JSON_QUERY Expressed Using JSON_TABLE
• 39-11 Accessing JSON Data Multiple Times To Extract Data
• 39-12 Using JSON_TABLE to Extract Data Without Multiple Parses
• 39-13 Projecting an Entire JSON Array as JSON Data
• 39-14 Projecting Elements of a JSON Array
• 39-15 Projecting Elements of a JSON Array Plus Other Data
• 39-16 JSON_TABLE: Projecting Array Elements Using NESTED
• 39-17 Defining a Relational View Over JSON Data
• 39-18 JSON Dot-Notation Query Compared with JSON_VALUE
• 39-19 JSON Dot-Notation Query Compared with JSON_QUERY
• 39-20 Creating a Bitmap Index for JSON_EXISTS
• 39-21 Creating a Bitmap Index for JSON_VALUE
• 39-22 Creating a Function-Based Index for a JSON Object Property: JSON_VALUE
• 39-23 Creating a Function-Based Index for a JSON Object Property: Dot Notation
• 39-24 Use of a JSON_VALUE Function-Based Index with a JSON_TABLE Query
• 39-25 JSON_VALUE Query with Explicit RETURNING NUMBER
• 39-26 JSON_VALUE Query with Explicit Numerical Conversion
• 39-27 JSON_VALUE Query with Implicit Numerical Conversion
• 39-28 Creating Virtual Columns for JSON Object Properties
• 39-29 Creating a Composite B-tree Index for JSON Object Properties
• 39-30 Two Ways to Query JSON Data Indexed with a Composite Index
• 39-31 Creating a JSON Search Index
• 39-32 Full-Text Query of JSON Data
• 39-33 Ad Hoc Queries of JSON Data
• 39-34 Execution Plan Indication that a JSON Search Index Is Used
• 39-35 Creating a Database Directory Object
• 39-36 Creating a Database Directory Object
• 39-37 Creating an External Table and Filling It from a JSON Dump File
• 39-38 Copying JSON Data from an External Table to a Relational Table
• A-1 Unannotated Purchase-Order XML Schema
• A-2 Annotated Purchase-Order XML Schema
• A-3 Revised Annotated Purchase-Order XML Schema
• A-4 PurchaseOrder.xsl XSLT Stylesheet
• A-5 Inserting XML Data into an XMLType Table Using C
• A-6 Using OCIXmlDbInitXmlCtx() and OCIXmlDbFreeXmlCtx()
• C-1 Updating XMLTYPE Using UPDATE and UPDATEXML (Deprecated)
• C-2 Updating Multiple Text Nodes and Attribute Values Using UPDATEXML (Deprecated)
• C-3 Updating Selected Nodes within a Collection Using UPDATEXML (Deprecated)
• C-4 NULL Updates with UPDATEXML (Deprecated) – Element and Attribute
• C-5 NULL Updates with UPDATEXML (Deprecated) – Text Node
• C-6 XPath Expressions in UPDATEXML Expression
• C-7 Object Relational Equivalent of UPDATEXML Expression
• C-8 Creating a View Using UPDATEXML (Deprecated)
• C-9 Insertion into a Collection Using INSERTCHILDXML (Deprecated)
• C-10 Inserting an Element that Uses a Namespace
• C-11 Insertion Before an Element Using INSERTXMLBEFORE (Deprecated)
• C-12 Insertion as the Last Child Using APPENDCHILDXML (Deprecated)
• C-13 Deletion of an Element Using DELETEXML (Deprecated)
• D-1 XML Schema Defining Documents with a Title To Be Translated
• D-2 Untranslated Instance Document
• D-3 XML Schema with Attribute xdb:translate for a Single-Valued Element
• D-4 Translated Document
• D-5 XML Schema with Attribute xdb:translate for a Multi-Valued Element
• D-6 Translated Document for an XML Schema with Multiple-Valued Elements
• D-7 Inserting a Document with No Language Information
• D-8 Document After Insertion into the Repository
• D-9 Inserting a Document with Language Information
• D-10 Document After Insertion
• E-1 Simple Query Using Oracle SQL Function CONTAINS
• E-2 Restricting a Query Using CONTAINS and WITHIN
• E-3 Restricting a Query Using CONTAINS and INPATH
• E-4 ora:contains with an Arbitrarily Complex Text Query
• E-5 CONTAINS Query with a Simple Boolean Operator
• E-6 CONTAINS Query with Complex Boolean
• E-7 CONTAINS Query with Stemming
• E-8 CONTAINS Query with Complex Query Expression
• E-9 Simple CONTAINS Query with SCORE
• E-10 WITHIN
• E-11 Nested WITHIN
• E-12 WITHIN an Attribute
• E-13 WITHIN and AND: Two Words in Some Comment Section
• E-14 WITHIN and AND: Two Words in the Same Comment
• E-15 WITHIN and AND: No Parentheses
• E-16 WITHIN and AND: Parentheses Illustrating Operator Precedence
• E-17 Structure Inside Full-Text Predicate: INPATH
• E-18 Structure Inside Full-Text Predicate: INPATH
• E-19 INPATH with Complex Path Expression (1)
• E-20 INPATH with Complex Path Expression (2)
• E-21 Nested INPATH
• E-22 Nested INPATH Rewritten
• E-23 Simple HASPATH
• E-24 HASPATH Equality
• E-25 HASPATH with Other Operators
• E-26 Scoping the Results of a CONTAINS Query
• E-27 Projecting the Result of a CONTAINS Query Using ora:contains
• E-28 Simple CONTEXT Index on Table PURCHASE_ORDERS
• E-29 Simple CONTEXT Index on XMLType Table with Path Section Group
• E-30 Simple CONTEXT Index on XMLType Column
• E-31 Simple CONTEXT Index on XMLType Table
• E-32 CONTAINS Query on XMLType Table
• E-33 CONTAINS: Default Case Matching
• E-34 Create a Preference for Mixed Case
• E-35 CONTEXT Index on PURCHASE_ORDERS Table, Mixed Case
• E-36 CONTAINS: Mixed (Exact) Case Matching
• E-37 Simple CONTEXT Index on purchase_orders Table with Path Section Group
• E-38 Using ora:contains with XMLQuery and XMLExists
• E-39 Create a Policy to Use with ora:contains
• E-40 Finding a Stopword Using ora:contains
• E-41 Finding a Stopword Using ora:contains and Policy my_nostopwords_policy
• E-42 ora:contains, Default Case-Sensitivity
• E-43 Create a Preference for Mixed Case
• E-44 Create a Policy with Mixed Case (Case-Insensitive)
• E-45 ora:contains, Case-Sensitive (1)
• E-46 ora:contains, Case-Sensitive (2)
• E-47 ora:contains in Large Table
• E-48 B-tree Index on ID
• E-49 ora:contains in Large Table, with Additional Predicate
• E-50 ora:contains Search for "electric"
• E-51 Using XQuery Pragma ora:use_text_index with ora:contains
• E-52 Purchase Order XML Document, po001.xml
• E-53 Create Table PURCHASE_ORDERS
• E-54 Create Table PURCHASE_ORDERS_XMLTYPE
• E-55 Create Table PURCHASE_ORDERS_XMLTYPE_TABLE
• E-56 Purchase-Order XML Schema for Full-Text Search Examples