Skip Headers
Oracle® XML DB Developer's Guide
10
g
Release 2 (10.2)
Part Number B14259-02
Home
Book List
Contents
Index
Master Index
Contact Us
Previous
Next
PDF
·
Mobi
·
ePub
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()
Scripting on this page enhances content navigation, but does not change the content in any way.