Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Part I Oracle XML DB Basics
-
1
Introduction to Oracle XML DB
- 1.1 Overview of Oracle XML DB
- 1.2 Oracle XML DB Benefits
- 1.3 Oracle XML DB Architecture
-
1.4
Oracle XML DB Features
- 1.4.1 XMLType Data Type
- 1.4.2 XMLType Storage Models
- 1.4.3 XML Schema Support in Oracle XML DB
- 1.4.4 DTD Support in Oracle XML DB
- 1.4.5 Static Data Dictionary Views Related to XML
- 1.4.6 SQL/XML Standard Functions
- 1.4.7 Programmatic Access to Oracle XML DB (Java, PL/SQL, and C)
- 1.4.8 Oracle XML DB Repository: Overview
- 1.5 Standards Supported by Oracle XML DB
- 1.6 Oracle XML DB Technical Support
- 1.7 Oracle XML DB Examples
- 1.8 Oracle XML DB Case Studies and Demonstrations on OTN
- 2 Getting Started with Oracle XML DB
-
3
Overview of How To Use Oracle XML DB
- 3.1 Creating XMLType Tables and Columns
- 3.2 Creating Virtual Columns on XMLType Data Stored as Binary XML
- 3.3 Partitioning Tables That Contain XMLType Data Stored as Binary XML
- 3.4 Enforcing XML Data Integrity Using the Database
-
3.5
Loading XML Content into Oracle XML DB
- 3.5.1 Loading XML Content Using SQL or PL/SQL
- 3.5.2 Loading XML Content Using Java
- 3.5.3 Loading XML Content Using C
- 3.5.4 Loading Large XML Files that Contain Small XML Documents
- 3.5.5 Loading Large XML Files Using SQL*Loader
- 3.5.6 Loading XML Documents into the Repository Using DBMS_XDB_REPOS
- 3.5.7 Loading Documents into the Repository Using Protocols
-
3.6
Querying XML Content Stored in Oracle XML DB
- 3.6.1 PurchaseOrder XML Document Used in Examples
- 3.6.2 Retrieving the Content of an XML Document Using Pseudocolumn OBJECT_VALUE
- 3.6.3 Accessing Fragments or Nodes of an XML Document Using XMLQUERY
- 3.6.4 Accessing Text Nodes and Attribute Values Using XMLCAST and XMLQUERY
- 3.6.5 Searching an XML Document Using XMLEXISTS, XMLCAST, and XMLQUERY
- 3.6.6 Performing SQL Operations on XMLType Fragments Using XMLTABLE
- 3.7 Updating XML Content Stored in Oracle XML DB
- 3.8 Generating XML Data from Relational Data
- 3.9 Character Sets of XML Documents
-
1
Introduction to Oracle XML DB
-
Part II Manipulation of XML Data in Oracle XML DB
-
4
XQuery and Oracle XML DB
- 4.1 Overview of the XQuery Language
- 4.2 Overview of XQuery in Oracle XML DB
- 4.3 SQL/XML Functions XMLQUERY, XMLTABLE, XMLExists, and XMLCast
- 4.4 URI Scheme oradb: Querying Table or View Data with XQuery
- 4.5 Oracle XQuery Extension Functions
- 4.6 Oracle XQuery Extension-Expression Pragmas
- 4.7 XQuery Static Type-Checking in Oracle XML DB
-
4.8
Oracle XML DB Support for XQuery
- 4.8.1 Support for XQuery and SQL
- 4.8.2 Support for XQuery Functions and Operators
-
4.8.3
Support for XQuery Full Text
- 4.8.3.1 XQuery Full Text, XML Schema-Based Data, and Pragma ora:no_schema
- 4.8.3.2 Restrictions on Using XQuery Full Text with XMLExists
- 4.8.3.3 Supported XQuery Full Text FTSelection Operators
- 4.8.3.4 Supported XQuery Full Text Match Options
- 4.8.3.5 Unsupported XQuery Full Text Features
- 4.8.3.6 XQuery Full Text Errors
-
5
Query and Update of XML Data
- 5.1 Using XQuery with Oracle XML DB
- 5.2 Querying XML Data Using SQL and PL/SQL
- 5.3 Using the SQL*Plus XQUERY Command
- 5.4 Using XQuery with XQJ to Access Database Data
- 5.5 Using XQuery with PL/SQL, JDBC, and ODP.NET to Access Database Data
- 5.6 Updating XML Data
- 5.7 Performance Tuning for XQuery
-
6
Indexes for XMLType Data
- 6.1 Oracle XML DB Tasks Involving Indexes
- 6.2 Overview of Indexing XMLType Data
-
6.3
XMLIndex
- 6.3.1 Advantages of XMLIndex
- 6.3.2 Structured and Unstructured XMLIndex Components
- 6.3.3 XMLIndex Structured Component
- 6.3.4 XMLIndex Unstructured Component
- 6.3.5 Creating, Dropping, Altering, and Examining an XMLIndex Index
- 6.3.6 Using XMLIndex with an Unstructured Component
-
6.3.7
Use of XMLIndex with a Structured Component
- 6.3.7.1 Using Namespaces and Storage Clauses with an XMLIndex Structured Component
- 6.3.7.2 Adding a Structured Component to an XMLIndex Index
- 6.3.7.3 Using Non-Blocking ALTER INDEX with an XMLIndex Structured Component
- 6.3.7.4 Modifying the Data Type of a Structured XMLIndex Component
- 6.3.7.5 Dropping an XMLIndex Structured Component
- 6.3.7.6 Indexing the Relational Tables of a Structured XMLIndex Component
- 6.3.8 How to Tell Whether XMLIndex is Used
- 6.3.9 Turning Off Use of XMLIndex
- 6.3.10 XMLIndex Path Subsetting: Specifying the Paths You Want to Index
- 6.3.11 Guidelines for Using XMLIndex with an Unstructured Component
- 6.3.12 Guidelines for Using XMLIndex with a Structured Component
- 6.3.13 XMLIndex Partitioning and Parallelism
- 6.3.14 Asynchronous (Deferred) Maintenance of XMLIndex Indexes
- 6.3.15 Collecting Statistics on XMLIndex Objects for the Cost-Based Optimizer
- 6.3.16 Data Dictionary Static Public Views Related to XMLIndex
-
6.3.17
PARAMETERS Clause for CREATE INDEX and ALTER INDEX
- 6.3.17.1 Using a Registered PARAMETERS Clause for XMLIndex
- 6.3.17.2 PARAMETERS Clause Syntax for CREATE INDEX and ALTER INDEX
- 6.3.17.3 Usage of XMLIndex_parameters_clause
- 6.3.17.4 Usage of XMLIndex_parameters
- 6.3.17.5 Usage of PATHS Clause
- 6.3.17.6 Usage of create_index_paths_clause and alter_index_paths_clause
- 6.3.17.7 Usage of pikey_clause, path_id_clause, and order_key_clause
- 6.3.17.8 Usage of value_clause
- 6.3.17.9 Usage of async_clause
- 6.3.17.10 Usage of groups_clause and alter_index_group_clause
- 6.3.17.11 Usage of XMLIndex_xmltable_clause
- 6.3.17.12 Usage of column_clause
-
6.4
Indexing XML Data for Full-Text
Queries
- 6.4.1 Creating and Using an XML Search Index
- 6.4.2 What To Do If an XML Search Index Is Not Picked Up
- 6.4.3 Pragma ora:no_schema: Using XML Schema-Based Data with XQuery Full Text
- 6.4.4 Pragma ora:use_xmltext_idx: Forcing the Use of an XML Search Index
- 6.4.5 Migrating from Using Oracle Text Index to XML Search Index
- 6.5 Indexing XMLType Data Stored Object-Relationally
- 7 Transformation and Validation of XMLType Data
-
4
XQuery and Oracle XML DB
-
Part III Relational Data To and From XML Data
-
8
Generation of XML Data from Relational Data
- 8.1 Overview of Generating XML Data
-
8.2
Generation of XML Data Using SQL Functions
- 8.2.1 XMLELEMENT and XMLATTRIBUTES SQL/XML Functions
- 8.2.2 XMLFOREST SQL/XML Function
- 8.2.3 XMLCONCAT SQL/XML Function
- 8.2.4 XMLAGG SQL/XML Function
- 8.2.5 XMLPI SQL/XML Function
- 8.2.6 XMLCOMMENT SQL/XML Function
- 8.2.7 XMLSERIALIZE SQL/XML Function
- 8.2.8 XMLPARSE SQL/XML Function
- 8.2.9 XMLCOLATTVAL Oracle SQL Function
- 8.2.10 XMLCDATA Oracle SQL Function
- 8.3 Generation of XML Data Using DBMS_XMLGEN
- 8.4 SYS_XMLAGG Oracle SQL Function
- 8.5 Ordering Query Results Before Aggregating, Using XMLAGG ORDER BY Clause
- 8.6 Returning a Rowset Using XMLTABLE
-
9
Relational Views over XML Data
- 9.1 Introduction to Creating and Using Relational Views over XML Data
- 9.2 Creating a Relational View over XML: One Row for Each XML Document
- 9.3 Creating a Relational View over XML: Mapping XML Nodes to Columns
- 9.4 Indexing Binary XML Data Exposed Using a Relational View
- 9.5 Querying XML Content As Relational Data
-
10
XMLType Views
- 10.1 What Are XMLType Views?
- 10.2 CREATE VIEW for XMLType Views: Syntax
- 10.3 Creating Non-Schema-Based XMLType Views
-
10.4
Creating XML Schema-Based XMLType Views
- 10.4.1 Creating XML Schema-Based XMLType Views Using SQL/XML Publishing Functions
- 10.4.2 Creating XML Schema-Based XMLType Views Using Object Types or Object Views
- 10.5 Creating XMLType Views from XMLType Tables
- 10.6 Referencing XMLType View Objects Using SQL Function REF
- 10.7 Using DML (Data Manipulation Language) on XMLType Views
-
8
Generation of XML Data from Relational Data
-
Part IV XMLType APIs
-
11
PL/SQL APIs for XMLType
- 11.1 Overview of PL/SQL APIs for XMLType
-
11.2
PL/SQL DOM API for XMLType (DBMS_XMLDOM)
- 11.2.1 Overview of the W3C Document Object Model (DOM) Recommendation
- 11.2.2 PL/SQL DOM API for XMLType (DBMS_XMLDOM): Features
- 11.2.3 Application Design Using Oracle XML Developer's Kit and Oracle XML DB
- 11.2.4 Preparing XML Data to Use the PL/SQL DOM API for XMLType
- 11.2.5 XML Schema Types Are Mapped to SQL Object Types
- 11.2.6 Wrap Existing Data as XML with XMLType Views
- 11.2.7 DBMS_XMLDOM Methods Supported by Oracle XML DB
- 11.2.8 PL/SQL DOM API for XMLType: Node Types
- 11.2.9 PL/SQL Function NEWDOMDOCUMENT and DOMDOCUMENT Nodes
- 11.2.10 DOM NodeList and NamedNodeMap Objects
- 11.2.11 Overview of Using the PL/SQL DOM API for XMLType (DBMS_XMLDOM)
- 11.2.12 PL/SQL DOM API for XMLType – Examples
- 11.2.13 Large Node Handling Using DBMS_XMLDOM
- 11.2.14 Get-Push Model for Large Node Handling
- 11.2.15 Get-Pull Model for Large Node Handling
- 11.2.16 Set-Pull Model for Large Node Handling
- 11.2.17 Set-Push Model for Large Node Handling
- 11.2.18 Determining Binary Stream or Character Stream for Large Node Handling
- 11.3 PL/SQL Parser API for XMLType (DBMS_XMLPARSER)
- 11.4 PL/SQL XSLT Processor for XMLType (DBMS_XSLPROCESSOR)
- 12 PL/SQL Package DBMS_XMLSTORE
-
13
Java DOM API for XMLType
- 13.1 Overview of Java DOM API for XMLType
- 13.2 Access to XMLType Data Using JDBC
- 13.3 Manipulating XML Database Documents Using JDBC
- 13.4 Loading a Large XML Document into the Database Using JDBC
- 13.5 MS Windows Java Security Manager Permissions for Java DOM API with a Thick Connection
- 13.6 Creating XML Schema-Based Documents
- 13.7 XMLType Instance Representation in Java (JDBC or SQLJ)
- 13.8 Classes of Java DOM API for XMLType
- 13.9 Using the Java DOM API for XMLType
- 13.10 Large XML Node Handling with Java
- 13.11 Using the Java DOM API and JDBC with Binary XML
-
14
C DOM API for XMLType
- 14.1 Overview of the C DOM API for XMLType
- 14.2 Access to XMLType Data Stored in the Database Using OCI
- 14.3 Creating XMLType Instances on the Client
- 14.4 XML Context Parameter for C DOM API Functions
- 14.5 Initializing and Terminating an XML Context
- 14.6 Using the C API for XML with Binary XML
- 14.7 Using the Oracle XML Developer's Kit Pull Parser with Oracle XML DB
- 14.8 Common XMLType Operations in C
- 15 Oracle XML DB and Oracle Data Provider for .NET
-
11
PL/SQL APIs for XMLType
-
Part V XML Schema and Object-Relational XMLType
-
16
Choice of XMLType Storage and Indexing
- 16.1 Introduction to Choosing an XMLType Storage Model and Indexing Approaches
- 16.2 XMLType Use Case Spectrum: Data-Centric to Document-Centric
-
16.3
Common Use Cases for XML Data Stored as XMLType
- 16.3.1 XMLType Use Case: No XML Fragment Updating or Querying
- 16.3.2 XMLType Use Case: Data Integration from Diverse Sources with Different XML Schemas
- 16.3.3 XMLType Use Case: Staged XML Data for ETL
- 16.3.4 XMLType Use Case: Semi-Structured XML Data
- 16.3.5 XMLType Use Case: Business Intelligence Queries
- 16.3.6 XMLType Use Case: XML Queries Involving Full-Text Search
- 16.4 XMLType Storage Model Considerations
- 16.5 XMLType Indexing Considerations
- 16.6 XMLType Storage Options: Relative Advantages
-
17
XML Schema Storage and Query: Basic
- 17.1 Overview of XML Schema
- 17.2 Overview of Using XML Schema with Oracle XML DB
-
17.3
XML Schema Registration with Oracle XML DB
- 17.3.1 XML Schema Registration Actions
- 17.3.2 Registering an XML Schema with Oracle XML DB
- 17.3.3 SQL Types and Tables Created During XML Schema Registration
- 17.3.4 Default Tables for Global Elements
- 17.3.5 Database Objects That Depend on Registered XML Schemas
- 17.3.6 Local and Global XML Schemas
- 17.3.7 Fully Qualified XML Schema URLs
- 17.3.8 Deletion of an XML Schema
- 17.3.9 Listing All Registered XML Schemas
- 17.4 Creation of XMLType Tables and Columns Based on XML Schemas
- 17.5 Ways to Identify XML Schema Instance Documents
- 17.6 XML Schema Data Types Are Mapped to Oracle XML DB Storage
-
18
XML Schema Storage and Query: Object-Relational Storage
-
18.1
Object-Relational Storage of XML Documents
- 18.1.1 How Collections Are Stored for Object-Relational XMLType Storage
- 18.1.2 SQL Types Created during XML Schema Registration for Object-Relational Storage
- 18.1.3 Default Tables Created during XML Schema Registration
- 18.1.4 Do Not Use Internal Constructs Generated during XML Schema Registration
- 18.1.5 Generated Names are Case Sensitive
- 18.1.6 SYS_XDBPD$ and DOM Fidelity for Object-Relational Storage
-
18.2
Oracle XML Schema Annotations
- 18.2.1 Common Uses of XML Schema Annotations
- 18.2.2 XML Schema Annotation Example
- 18.2.3 Annotating an XML Schema Using DBMS_XMLSCHEMA_ANNOTATE
- 18.2.4 Available Oracle XML DB XML Schema Annotations
-
18.2.5
XML Schema Annotation Guidelines for Object-Relational Storage
- 18.2.5.1 Avoid Creation of Unnecessary Tables for Unused Top-Level Elements
- 18.2.5.2 Provide Your Own Names for Default Tables
- 18.2.5.3 Turn Off DOM Fidelity If Not Needed
- 18.2.5.4 Annotate Time-Related Elements with a Timestamp Data Type
- 18.2.5.5 Add Table and Column Properties
- 18.2.5.6 Store Large Collections Out of Line
- 18.2.6 Querying a Registered XML Schema to Obtain Annotations
- 18.3 Use DBMS_XMLSCHEMA to Map XML Schema Data Types to SQL Data Types
- 18.4 complexType Extensions and Restrictions in Oracle XML DB
- 18.5 Creating XML Schema-Based XMLType Columns and Tables
- 18.6 Overview of Partitioning XMLType Tables and Columns Stored Object-Relationally
- 18.7 Specification of Relational Constraints on XMLType Tables and Columns
- 18.8 Out-Of-Line Storage of XMLType Data
- 18.9 Considerations for Working with Complex or Large XML Schemas
- 18.10 Debugging XML Schema Registration for XML Data Stored Object-Relationally
-
18.1
Object-Relational Storage of XML Documents
-
19
XPath Rewrite for Object-Relational Storage
- 19.1 Overview of XPath Rewrite for Object-Relational Storage
- 19.2 Common XPath Expressions that Are Rewritten
- 19.3 XPath Rewrite for Out-Of-Line Tables
-
19.4
Guidelines for Using Execution Plans to Analyze and Optimize XPath Queries
- 19.4.1 Guideline: Look for underlying tables versus XML functions in execution plans
- 19.4.2 Guideline: Name the object-relational tables, so you recognize them in execution plans
- 19.4.3 Guideline: Create an index on a column targeted by a predicate
- 19.4.4 Guideline: Create indexes on ordered collection tables
- 19.4.5 Guideline: Use XMLOptimizationCheck to determine why a query is not rewritten
-
20
XML Schema Evolution
- 20.1 Overview of XML Schema Evolution
-
20.2
Copy-Based Schema Evolution
- 20.2.1 Scenario for Copy-Based Evolution
- 20.2.2 COPYEVOLVE Parameters and Errors
- 20.2.3 Limitations of Procedure COPYEVOLVE
-
20.2.4
Guidelines for Using Procedure COPYEVOLVE
- 20.2.4.1 Top-Level Element Name Changes
- 20.2.4.2 User-Created Virtual Columns of Tables Other Than Default Tables
- 20.2.4.3 Ensure That the XML Schema and Dependents Are Not Used by Concurrent Sessions
- 20.2.4.4 Rollback When Procedure DBMS_XMLSCHEMA.COPYEVOLVE Raises an Error
- 20.2.4.5 Failed Rollback From Insufficient Privileges
- 20.2.4.6 Privileges Needed for XML Schema Evolution
- 20.2.5 Update of Existing XML Instance Documents Using an XSLT Stylesheet
- 20.2.6 Examples of Using Procedure COPYEVOLVE
-
20.3
In-Place XML Schema Evolution
- 20.3.1 Restrictions for In-Place XML Schema Evolution
- 20.3.2 Supported Operations for In-Place XML Schema Evolution
- 20.3.3 Guidelines for Using In-Place XML Schema Evolution
- 20.3.4 inPlaceEvolve Parameters
- 20.3.5 The diffXML Parameter Document
-
16
Choice of XMLType Storage and Indexing
-
Part VI Oracle XML DB Repository
-
21
Access to Oracle XML DB Repository
Data
- 21.1 Overview of Oracle XML DB Repository
- 21.2 Repository Terminology and Supplied Resources
- 21.3 Oracle XML DB Repository Resources
- 21.4 Navigational or Path Access to Repository Resources
- 21.5 Query-Based Access to Repository Resources
- 21.6 Servlet Access to Repository Resources
- 21.7 Operations on Repository Resources
- 21.8 Accessing the Content of Repository Resources Using SQL
- 21.9 Access to the Content of XML Schema-Based Documents
- 21.10 Update of the Content of Repository Documents
- 21.11 Querying Resources in RESOURCE_VIEW and PATH_VIEW
- 21.12 Oracle XML DB Hierarchical Repository Index
- 22 Configuration of Oracle XML DB Repository
-
23
Use of XLink and XInclude with Oracle XML DB
- 23.1 Overview of XLink and XInclude
- 23.2 Link Types for XLink and XInclude
- 23.3 XInclude: Compound Documents
- 23.4 Oracle XML DB Support for XLink
- 23.5 Oracle XML DB Support for XInclude
- 23.6 Use View DOCUMENT_LINKS to Examine XLink and XInclude Links
-
23.7
Configuration of Repository Resources for XLink and XInclude
- 23.7.1 Configure the Treatment of Unresolved Links: Attribute UnresolvedLink
- 23.7.2 Configure the Type of Document Links to Create: Element LinkType
- 23.7.3 Configure the Path Format for Retrieval: Element PathFormat
- 23.7.4 Configure Conflict-Resolution for XInclude: Element ConflictRule
- 23.7.5 Configure the Decomposition of Documents Using XInclude: Element SectionConfig
- 23.7.6 XLink and XInclude Configuration Examples
- 23.8 Manage XLink and XInclude Links Using DBMS_XDB_REPOS.processLinks
-
24
Repository Access Using RESOURCE_VIEW and PATH_VIEW
- 24.1 Overview of Oracle XML DB RESOURCE_VIEW and PATH_VIEW
- 24.2 Oracle SQL Functions That Use RESOURCE_VIEW and PATH_VIEW
- 24.3 Accessing Repository Data Paths, Resources and Links: Examples
- 24.4 Deleting Repository Resources: Examples
- 24.5 Updating Repository Resources: Examples
- 24.6 Working with Multiple Oracle XML DB Resources
- 24.7 Performance Guidelines for Oracle XML DB Repository Operations
- 24.8 Searching for Resources Using Oracle Text
- 25 Resource Versions
- 26 PL/SQL Access to Oracle XML DB Repository
-
27
Repository Access Control
- 27.1 Access Control Concepts
- 27.2 Database Privileges for Repository Operations
- 27.3 Privileges
- 27.4 ACLs and ACEs
-
27.5
Overview of Working with Access Control Lists (ACLs)
- 27.5.1 Creating an ACL Using DBMS_XDB_REPOS.CREATERESOURCE
- 27.5.2 Retrieving an ACL Document, Given its Repository Path
- 27.5.3 Setting the ACL of a Resource
- 27.5.4 Deleting an ACL
- 27.5.5 Updating an ACL
- 27.5.6 Retrieving the ACL Document that Protects a Given Resource
- 27.5.7 Retrieving Privileges Granted to the Current User for a Particular Resource
- 27.5.8 Checking Whether the Current User Has Privileges on a Resource
- 27.5.9 Checking Whether a User Has Privileges Using the ACL and Resource Owner
- 27.5.10 Retrieving the Path of the ACL that Protects a Given Resource
- 27.5.11 Retrieving the Paths of All Resources Protected by a Given ACL
- 27.6 ACL Caching
- 27.7 Repository Resources and Database Table Security
- 27.8 Integration Of Oracle XML DB with LDAP
-
28
Repository Access Using Protocols
- 28.1 Overview of Oracle XML DB Protocol Server
-
28.2
Oracle XML DB Protocol Server Configuration Management
- 28.2.1 Protocol Server Configuration Parameters
- 28.2.2 Configuring Secure HTTP (HTTPS)
- 28.2.3 Using Listener Status to Check Port Configuration
- 28.2.4 Configuring Protocol Port Parameters after Database Consolidation
- 28.2.5 Configuration and Management of Authentication Mechanisms for HTTP
- 28.2.6 Oracle XML DB Repository and File-System Resources
- 28.2.7 Protocol Server Handles XML Schema-Based or Non-Schema-Based XML Documents
- 28.2.8 Event-Based Logging
- 28.2.9 Auditing of HTTP and FTP Protocols
-
28.3
FTP and the Oracle XML DB Protocol Server
-
28.3.1
Oracle XML DB Protocol Server: FTP Features
- 28.3.1.1 FTP Features That Are Not Supported
- 28.3.1.2 Supported FTP Client Methods
- 28.3.1.3 FTP Quote Methods
- 28.3.1.4 Uploading Content to Oracle XML DB Repository Using FTP
- 28.3.1.5 Using FTP with Oracle ASM Files
- 28.3.1.6 Using FTP on the Standard Port Instead of the Oracle XML DB Default Port
- 28.3.1.7 Using IPv6 IP Addresses with FTP
- 28.3.1.8 FTP Server Session Management
- 28.3.1.9 Handling Error 421. Modifying the Default Timeout Value of an FTP Session
- 28.3.1.10 FTP Client Failure in Passive Mode
-
28.3.1
Oracle XML DB Protocol Server: FTP Features
-
28.4
HTTP(S) and Oracle XML DB Protocol Server
-
28.4.1
Oracle XML DB Protocol Server: HTTP(S) Features
- 28.4.1.1 Supported HTTP(S) Client Methods
- 28.4.1.2 Using HTTP(S) on a Standard Port Instead of an Oracle XML DB Default Port
- 28.4.1.3 Use of IPv6 IP Addresses with HTTP(S)
- 28.4.1.4 HTTPS: Support for Secure HTTP
- 28.4.1.5 Control of URL Expiration Time
- 28.4.1.6 Anonymous Access to Oracle XML DB Repository Using HTTP
- 28.4.1.7 Use of Java Servlets with HTTP(S)
- 28.4.1.8 Embedded PL/SQL Gateway
- 28.4.1.9 Transmission of Multibyte Data From a Client
- 28.4.1.10 Characters That Are Not ASCII in URLs
- 28.4.1.11 Character Sets for HTTP(S)
-
28.4.1
Oracle XML DB Protocol Server: HTTP(S) Features
- 28.5 WebDAV and Oracle XML DB
-
29
User-Defined Repository Metadata
- 29.1 Overview of Metadata and XML
- 29.2 Using XML Schemas to Define Resource Metadata
- 29.3 Addition, Modification, and Deletion of Resource Metadata
- 29.4 Querying XML Schema-Based Resource Metadata
- 29.5 XML Image Metadata from Binary Image Metadata
- 29.6 Adding Non-Schema-Based Resource Metadata
- 29.7 PL/SQL Procedures Affecting Resource Metadata
- 30 Oracle XML DB Repository Events
-
31
Guidelines for Oracle XML DB Applications in Java
- 31.1 Overview of Oracle XML DB Java Applications
- 31.2 HTTP(S): Access Java Servlets or Directly Access XMLType Resources
- 31.3 Use JDBC XMLType Support to Access Many XMLType Object Elements
- 31.4 Use Servlets to Manipulate and Write Out Data Quickly as XML
- 31.5 Oracle XML DB Java Servlet Support Restrictions
- 31.6 Configuration of Oracle XML DB Servlets
- 31.7 HTTP Request Processing for Oracle XML DB Servlets
- 31.8 Session Pool and Oracle XML DB Servlets
- 31.9 Native XML Stream Support
- 31.10 Oracle XML DB Servlet APIs
- 31.11 Oracle XML DB Servlet Example
-
32
Data Access Using URIs
- 32.1 Overview of Oracle XML DB URI Features
- 32.2 URIs and URLs
- 32.3 URIType and its Subtypes
- 32.4 Accessing Data Using URIType Instances
- 32.5 XDBUris: Pointers to Repository Resources
- 32.6 DBUris: Pointers to Database Data
- 32.7 Create New Subtypes of URIType Using Package URIFACTORY
- 32.8 SYS_DBURIGEN SQL Function
- 32.9 DBUriServlet
- 33 Native Oracle XML DB Web Services
-
21
Access to Oracle XML DB Repository
Data
-
Part VII Oracle Tools that Support Oracle XML DB
-
34
Administration of Oracle XML DB
- 34.1 Upgrade or Downgrade of an Existing Oracle XML DB Installation
- 34.2 Administration of Oracle XML DB Using Oracle Enterprise Manager
-
34.3
Configuration of Oracle XML DB Using xdbconfig.xml
-
34.3.1
Oracle XML DB Configuration File, xdbconfig.xml
- 34.3.1.1 Element xdbconfig (Top-Level)
- 34.3.1.2 Element sysconfig (Child of xdbconfig)
- 34.3.1.3 Element userconfig (Child of xdbconfig)
- 34.3.1.4 Element protocolconfig (Child of sysconfig)
- 34.3.1.5 Element httpconfig (Child of protocolconfig)
- 34.3.1.6 Element servlet (Descendant of httpconfig)
- 34.3.1.7 Oracle XML DB Configuration File Example
- 34.3.1.8 Oracle XML DB Configuration API
- 34.3.1.9 Configuration of Mappings from Default Namespace to Schema Location
- 34.3.1.10 Configuration of XML File Extensions
-
34.3.1
Oracle XML DB Configuration File, xdbconfig.xml
- 34.4 Oracle XML DB and Database Consolidation
- 34.5 Package DBMS_XDB_ADMIN
- 35 How to Load XML Data
- 36 Export and Import of Oracle XML DB Data
-
37
XML Data Exchange Using Oracle Database Advanced Queuing
- 37.1 XML and Oracle Database Advanced Queuing
- 37.2 Oracle Database Advanced Queuing
- 37.3 XMLType Attributes in Object Types
- 37.4 Internet Data Access Presentation (iDAP): SOAP for AQ
- 37.5 iDAP Architecture
-
37.6
Guidelines for Using XML and Oracle Database Advanced Queuing
- 37.6.1 Store AQ XML Messages with Many PDFs as One Record
- 37.6.2 Add New Recipients After Messages Are Enqueued
- 37.6.3 Enqueue and Dequeue XML Messages
- 37.6.4 Parse Messages with XML Content from AQ Queues
- 37.6.5 Prevent the Listener from Stopping Until an XML Document Is Processed
- 37.6.6 HTTPS with AQ
- 37.6.7 Store XML in Oracle AQ Message Payloads
- 37.6.8 iDAP and SOAP
-
34
Administration of Oracle XML DB
-
Appendixes
-
A
Oracle-Supplied XML Schemas and Examples
- A.1 XDBResource.xsd: XML Schema for Oracle XML DB Resources
- A.2 XDBResConfig.xsd: XML Schema for Resource Configuration
- A.3 acl.xsd: XML Schema for ACLs
- A.4 xdbconfig.xsd: XML Schema for Configuring Oracle XML DB
- A.5 xdiff.xsd: XML Schema for Comparing Schemas for In-Place Evolution
- A.6 Purchase-Order XML Schemas
- A.7 XSLT Stylesheet Example, PurchaseOrder.xsl
- A.8 Loading XML Data Using C (OCI)
- A.9 Initializing and Terminating an XML Context (OCI)
- B Oracle XML DB Restrictions
-
A
Oracle-Supplied XML Schemas and Examples
- Index