List of Examples

Previous Next JavaScript must be enabled to correctly display this content

List of Examples

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 Tables That Have an XMLIndex Structured Component
6-4 Exchange-Partitioning Reference-Partitioned Tables That Use XMLIndex
6-5 Data Used in Example of Exchange-Partitioning for Reference-Partitioned Tables
6-6 Path Table Contents for Two Purchase Orders
6-7 Creating an XMLIndex Index
6-8 Obtaining the Name of an XMLIndex Index on a Particular Table
6-9 Renaming and Dropping an XMLIndex Index
6-10 Naming the Path Table of an XMLIndex Index
6-11 Determining the System-Generated Name of an XMLIndex Path Table
6-12 Specifying Storage Options When Creating an XMLIndex Index
6-13 Dropping an XMLIndex Unstructured Component
6-14 Determining the Names of the Secondary Indexes of an XMLIndex Index
6-15 Creating a Function-Based Index on Path-Table Column VALUE
6-16 Trying to Create a Numeric Index on Path-Table Column VALUE Directly
6-17 Creating a Numeric Index on Column VALUE with Procedure createNumberIndex
6-18 Creating a Date Index on Column VALUE with Procedure createDateIndex
6-19 Creating an Oracle Text CONTEXT Index on Path-Table Column VALUE
6-20 Showing All Secondary Indexes on an XMLIndex Path Table
6-21 XMLIndex with a Structured Component, Using Namespaces and Storage Options
6-22 XMLIndex with a Structured Component, Specifying TABLESPACE at the Index Level
6-23 XMLIndex Index: Adding a Structured Component
6-24 Using DBMS_XMLINDEX.PROCESS_PENDING To Index XML Data
6-25 Dropping an XMLIndex Structured Component
6-26 Creating a B-tree Index on an XMLIndex Index Content Table
6-27 Checking Whether an XMLIndex Unstructured Component Is Used
6-28 Obtaining the Name of an XMLIndex Index from Its Path-Table Name
6-29 Extracting Data from an XML Fragment Using XMLIndex
6-30 Using a Structured XMLIndex Component for a Query with Two Predicates
6-31 Using a Structured XMLIndex Component for a Query with Multilevel Chaining
6-32 Turning Off XMLIndex Using Optimizer Hints
6-33 XMLIndex Path Subsetting with CREATE INDEX
6-34 XMLIndex Path Subsetting with ALTER INDEX
6-35 XMLIndex Path Subsetting Using a Namespace Prefix
6-36 Creating an XMLIndex Index in Parallel
6-37 Using Different PARALLEL Degrees for XMLIndex Internal Objects
6-38 Specifying Deferred Synchronization for XMLIndex
6-39 Manually Synchronizing an XMLIndex Index Using SYNCINDEX
6-40 Automatic Collection of Statistics on XMLIndex Objects
6-41 Creating an XML Search Index
6-42 XQuery Full Text Query
6-43 Execution Plan for XQuery Full Text Query
6-44 XQuery Full Text Query with XML Schema-Based Data: Error ORA-18177
6-45 Using XQuery Pragma ora:no_schema with XML Schema-Based Data
6-46 Full-Text Query with XQuery Pragma ora:use_xmltext_idx
6-47 CREATE INDEX Using XMLCAST and XMLQUERY on a Singleton Element
6-48 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 XMLCOLATTVAL: Generating Elements with Attribute and Child Elements
8-20 Using Oracle SQL Function XMLCDATA
8-21 DBMS_XMLGEN: Generating Simple XML
8-22 DBMS_XMLGEN: Generating Simple XML with Pagination (Fetch)
8-23 DBMS_XMLGEN: Generating XML Using Object Types
8-24 DBMS_XMLGEN: Generating XML Using User-Defined Data-Type Instances
8-25 DBMS_XMLGEN: Generating an XML Purchase Order
8-26 DBMS_XMLGEN: Generating a New Context Handle from a REF Cursor
8-27 DBMS_XMLGEN: Specifying NULL Handling
8-28 DBMS_XMLGEN: Generating Recursive XML with a Hierarchical Query
8-29 DBMS_XMLGEN: Binding Query Variables Using SETBINDVALUE()
8-30 Using XMLAGG ORDER BY Clause
8-31 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 Creating and Registering XML Schema emp_complex.xsd
10-11 Creating XMLType View emp_xml Using Object Type emp_t
10-12 Creating an Object View and an XMLType View Based 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, and Updating It
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 getString() and getCLOB()
13-3 Returning XMLType Data Using getSQLXML()
13-4 Returning XMLType Data Using an Output Parameter
13-5 Updating an XMLType Column Using SQL Constructor XMLType and Java String
13-6 Updating an XMLType Column Using SQLXML
13-7 Retrieving Metadata About an XMLType Column Using JDBC
13-8 Updating an XMLType Column Using JDBC
13-9 Updated Purchase-Order Document
13-10 Inserting an XMLType column using JDBC
13-11 Converting an XML String to an OracleClob Instance
13-12 Policy File Granting Permissions for Java DOM API
13-13 Creating a DOM Object with the Java DOM API
13-14 Using the Java DOM API with a Binary XML Column
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 Text Document Using UPDATE and XQuery Update on the Resource
21-10 Updating an XML Node Using UPDATE and XQuery Update on the Resource
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 An Oracle XML DB Servlet
31-2 Registering and Mapping an Oracle XML DB Servlet
32-1 Using HTTPURIType PL/SQL Method GETCONTENTTYPE()
32-2 Creating and Querying a URI Column
32-3 Using Different Kinds of URI, Created in Different Ways
32-4 Access a Repository Resource by URI Using an XDBUri
32-5 Using PL/SQL Method GETXML with XMLCAST and XMLQUERY
32-6 Targeting a Complete Table Using a DBUri
32-7 Targeting a Particular Row in a Table Using a DBUri
32-8 Targeting a Specific Column Using a DBUri
32-9 Targeting an Object Column with Specific Attribute Values Using a DBUri
32-10 Retrieve Only the Text Value of a Node Using a DBUri
32-11 Targeting a Collection Using a DBUri
32-12 URIFACTORY: Registering the ECOM Protocol
32-13 SYS_DBURIGEN: Generating a DBUri that Targets a Column
32-14 Passing Columns with Single Arguments to SYS_DBURIGEN
32-15 Inserting Database References Using SYS_DBURIGEN
32-16 Creating the Travel Story Table
32-17 A Function that Returns the First 20 Characters
32-18 Creating a Travel View for Use with SYS_DBURIGEN
32-19 Retrieving a URL Using SYS_DBURIGEN in RETURNING Clause
32-20 Changing the Installation Location of DBUriServlet
32-21 Restricting Servlet Access to a Database Role
32-22 Registering a Handler for a DBUri Prefix
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 Data File filelist.dat: List of XML Files to Load
35-2 Control File load_datra.ctl, for Loading Purchase-Order XML Documents
35-3 Loading XML Data Using Shell Command sqlldr
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 Creating a Queue Table and Queue
37-2 Creating a Transformation to Convert Message Data to XML
37-3 Applying a Transformation before Sending Messages Overseas
37-4 XMLType and AQ: Dequeuing Messages
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 Code Fragment Showing How to Get a Repository Object
C-2 Uploading a File Using Oracle XML DB Content Connector
C-3 Uploading a File Using the Command Line