Index

A B C D E F G H I J L M N O P Q R S T U V W X

A

access control lists (ACLs), 23.1

default, 23.2

defined, 18.2.1

managing from Enterprise Manager, 26.5.3

summary, 1.2.2.2

Advanced Queuing (AQ)

definition, 29.1

hub-and-spoke architecture support, 29.2.2

IDAP, 29.5

message management support, 29.2.3

messaging scenarios, 29.2.1

point-to-point support, 29.1

publish/subscribe support, 29.1

XMLType queue payloads, 29.6.1

aggregating

XSQL and XMLAgg, 15.13

any, 18.3

attributes

collection, 5.13

columnProps, 5.4.7

Container, 18.3.2

defaultTable, 5.4.7

in elements, 5.9

maintainDOM, 5.7.2, 5.14.5.2.1, 6.9.2

maintainOrder, 5.13

mapping any, 6.6.3

maxOccurs, 5.13

namespaces, 5.3

of XMLFormat, 15.11.1

passing to SYS_DBURIGEN, 17.13.1

REF, 6.3, 6.8.2

setting to NULL, 4.3.2

SQLInLine, 6.3, 6.3

SQLName, 5.9, 5.9

SQLSchema, 5.4.6

SQLType, 5.9, 6.5.2

SQLType attribute, 5.10.1

SYS_XDBPD$, 5.14.5, 5.14.5.2.1, 6.9.2

tableProps, 5.4.7

XMLAttributes in XMLElement, 15.3.1

XMLDATA, 5.14.1, 6.8.2.1

XMLType, in AQ, 29.6.1

xsi.NamespaceSchemaLocation, 5.2

xsi.noNamespaceSchemaLocation, 16.3.1.3

authenticatedUser

DBuri security, 17.14.3

B

B*Tree, 1.2.1, 3.1.5

C

cascading style sheets, see CSS, D.4

catalog views, F.6

cfg_get, 21.5.1, A.6.1

cfg_refresh, A.6.3

character sets

importing and exporting XML data, 28.6

CharacterData, 10.2.11

collection attribute, 5.13

collection index, 5.14.5.1

columnProps attribute, 5.4.7

complexType

cycling, 6.8.2

cycling between, 6.8.2

elements, B.2.1

handling inheritance, 6.6.1

in XML schema, explained, B.14.2

mapping any and any attributes, 6.6.3

mapping to SQL, 5.13

restrictions, 6.6

concatenating

elements using XMLConcat, 15.6

configuring

API, A.6

protocol server in Oracle XML DB, 24.2.1

servlet, example, 25.9.2

servlets in Oracle XML DB, 25.4

using Enterprise Manager, 26.4

constraints

on XMLType columns, 5.8.3

CONTAINS, 4.4

contents, element, 18.3

CREATE TABLE

XMLType storage, 5.8.1

createFolder(), 21.3.1

createXML() function, 10.1.1.3

creating

XML schema-based tables, columns, 5.8

CSS and XSL, D.4

CTXXPATH

storage preferences, 4.4.4.3

cycling in complexTypes

self-referencing, 6.8.2

D

date

format conversion in updateXML(), 5.14.5.2.5, 6.12

format conversions for XML, 5.14.5.1

mapping to SQL, 5.12

DBMS_METADATA, 17.2.2

DBMS_XDB, F.7

cfg_get, A.6.1

cfg_refresh, A.6.3

configuration management, 21.5

LockResource, 21.3

overview, 21.2, 21.2

security, 21.4

DBMS_XDB_VERSION, 19.1, F.10

subprograms, 19.3

DBMS_XDBT, F.11

DBMS_XMLDOM, 10.2, F.2

DBMS_XMLDOM package, 10.2.7

DBMS_XMLGEN, 15.9, F.8

generating complex XML, 15.9.2

generating XML, 15.1.3

DBMS_XMLPARSER, 10.3, F.3

DBMS_XMLSCHEMA, 5.4, F.5

deleteSchema, 5.4

generateSchema() function, 6.1

generateSchemas() function, 6.1

mapping of types, 5.11

registerSchema, 5.4

DBMS_XSLPROCESSOR, F.4

DBMS_XSLPROCESSOR package, 10.4

dbmsxsch.sql, F.5

DBUri, 17.5.1

and object references, 17.6.5

identifying a row, 17.6.2

identifying a target column, 17.6.3

retrieving column text value, 17.6.4

retrieving the whole table, 17.6

security, 17.14.3

servlet, 17.14

servlet, installation, 17.14.2

syntax guidelines, 17.5.3

URL specification, 17.5.2

XPath expressions in, 17.5.3.1

DBUri-refs, 17.5

HTTP access, 17.14

where it can be used, 17.6.7

DBUriType

defined, 17.1

notation for fragments, 17.5.2

stores references to data, 17.3

default table

creating, 5.4.7

defaultTable attribute, 5.4.7

deleting

resources, 20.7.3

XML schema using DBMS_XMLSCHEMA, 5.4.11

DEPTH, 20.6

document

no order, 6.9.2

no order with extract(), 6.11.2

order, 5.14.5.2.1, 6.9.1

order with extract(), 6.11.1

order, query rewrites with collection, 5.14.5.1

ordering preserved in mapping, 5.14.5.2.4, 6.11.1

DOM

differences, and SAX, 10.2.1.3

fidelity, 5.7, 5.7

fidelity, default, 5.14.5

fidelity, in structured storage, 3.1.4

fidelity, SYS_XDBPD$, 5.7.2

introduced, 10.2.1

Java API, 12.1

Java API features, 12.4

Java API, XMLType classes, 12.5

NodeList, 10.2.11

non-supported, 10.2.1.1

DOM API for PL/SQL, 10.2

DTD

limitations, B.14.1

E

elementFormDefault, 5.14.5.1

elements

any, 18.3

complexType, B.2.1

Contents, Resource index, 18.3

simpleType, B.2.1

XDBBinary, 18.5.1.3

XML, 10.1.2

enqueuing

adding new recipients after, 29.7.2

EQUALS_PATH

summary, 20.1.4

syntax, 20.4

existsNode

dequeuing messages, 2.8.1

finding XML elements, nodes, 4.2.4

query rewrite, 5.14

XPath rewrites, 6.9

exporting XML table, 28.3

extract, 5.14.5.2.4, 6.11

dequeing messages, 2.8.1

mapping, 5.14.5.2.4, 6.11.1

query rewrite, 5.14

rewrite in XPath expressions, 5.14.5.2.4, 6.11

extracting

data from XML, 4.2.7

extractValue

creating indexes, query rewrite, 5.14.5.2.2, 6.10

query rewrite, 5.14

rewrites in XPath expressions, 5.14.5.2.2, 6.10

F

factory method, 17.11

folder, defined, 18.2.1

foldering

explained, 18.1

summary, 1.2.2.2

FORCE mode option, 5.4.11.1

Frequently Asked Questions (FAQs)

versioning, 19.4

FTP

configuration parameters, Oracle XMl DB, 24.2.1

creating default tables, 5.4.7

protocol server, features, 24.3

function-based index

creating in Enterprise Manager, 26.7.7

functions

DBUriType, 17.7

isSchemaValid, 8.3.5

isSchemaValidated, 8.3.3

schemaValidate, 8.3.2

setSchemaValidated, 8.3.4

SYS_DBURIGEN, 17.13, 17.13

SYS_XMLAgg, 15.12

SYS_XMLGEN, 15.11

transform, 8.1.1

updateXML, 6.12

XMLAgg, 15.7

XMLColAttVal, 15.8

XMLConcat, 15.6

XMLElement, 15.3

XMLForest, 15.4

XMLSequence, 15.5, 15.5

XMLTransform, 8.1.1

G

generating

DBUriType using SYS_DBURIGEN, 17.13

generating XML

DBMS_XMLGEN example, 15.9.2

element forest

XMLColAttVal, 15.8

from SQL, DBMS_XMLGEN, 15.9

one document from another, 15.5

SQL, SYS_XMLGEN, 15.11

SYS_XMLAgg, 15.12

using SQL functions, 15.1.4

XML SQL Utility (XSU), 15.14

XMLAgg, 15.7

XMLConcat, 15.6

XMLElement, 15.3

XMLForest, 15.4

XMLSequence, 15.5

XSQL, 15.13

getBlobVal(), 12.2

getBlobVal() function, 10.1.1.3

getXMLType(), 12.5

global XML schema, 5.6.2

H

HTTP

access for DBUri-refs, 17.14

accessing Java servlet or XMLType, 25.2.1

accessing Repository resources, 18.5.1.2

configuration parameters, WebDAV, 24.2.1

creating default tables, 5.4.7

HttpUriType, DBUriType, 17.10.1

improved performance, 24.1.1.1

Oracle XML DB servlets, 25.5

protocol server, features, 24.4

requests, 25.5

servlets, 25.3

UriFactory, 17.14.4

using UriRefs to store pointers, 17.3.1

HttpUriType

accesses remote pages, 17.3

defined, 17.1

hub-and-spoke architecture, enabled by AQ, 29.2.2

I

IDAP

architecture, 29.6

transmitted over Internet, 29.5

IMPORT/EXPORT

in XML DB, 28.1.1

index

collection, 5.14.5.1

indexing

XMLType, 4.4

Information Set

W3C introducing XML, C.6

inheritance

in XML schema, restrictions in complexTypes, 6.6.1

inserting

new instances, 6.6.4

installing

from scratch, Oracle XML DB, A.1.1

manually without DBCA, A.1.3

instance document

specifying root element namespace, 5.2

XML, described, B.14.2

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 29.5

isSchemaValid, 8.3.5

isSchemaValidated, 8.3.3

J

Java

Oracle XML DB guidelines, 25.2

using JDBC to access XMLType objects, 25.2.2

writing Oracle XML DB applications, 25.1

Java DOM API for XMLType, E.1

JDBC

accessing documents, 12.2.3.1

manipulating data, 12.2.4

using SQL to determine object properties, 22.4

JNDI, 12.2.2

using Resource API, 22.2

L

lazy XML loading (lazy manifestation), 10.1.1.1

LOBs

mapping XML fragments to, 6.5.2

location path, C.3

LockResource, 21.3

M

maintainDOM attribute, 5.7.2, 5.14.5.2.1, 6.9.2

maintainOrder attribute, 5.13

mapping

collection predicates, 5.14.5.1

complexType any, 6.6.3

complexTypes to SQL, 5.13

overriding using SQLType attribute, 5.11.2.1

predicates, 5.14.5.1

scalar nodes, 5.14.5.1

simpleContent to object types, 6.6.2

simpleType XML string to VARCHAR2, 5.12.1

simpleTypes, 5.12

type, setting element, 5.11.2

maxOccurs attribute, 5.13

MIME

overriding with DBUri servlet, 17.14.1

modes

FORCE, 5.4.11.1

MULTISET operator

using with SYS_XMLGEN selects, 15.11.1

N

NamedNodeMap object, 10.2.11

namespace

handling in query rewrites, 5.14.5.1

handling in XPath, 5.14.5.1

W3C introducing, C.5

XML schema URL, 5.2

xmlns, D.1.2

naming SQL objects

SQLName, SQLType attributes, 5.9

navigational access, 18.5

nested

generating nested XML using DBMS_XMLGEN, 15.9.2

XML, generating with XMLElement, 15.3.1

XMLAgg functions and XSQL, 15.13

newDOMDocument() function, 10.2.10

NodeList object, 10.2.11

NULL

mapping to in XPath, 5.14.5.1

O

object references and DBUri, 17.6.5

operators

CONTAINS, 4.4

DEPTH, 20.6

EQUALS_PATH, 20.4

MULTISET and SYS_XMLGEN, 15.11.1

PATH, 20.5

UNDER_PATH, 20.3

XMLIsValid, 8.3.1

Oracle Enterprise Manager

configuring Oracle XML DB, 26.4

console, 26.3

creating a view based on XML schema, 26.7.6

creating function-based index, 26.7.7

features, 26.2

granting privileges, XML Tab, 26.5.4

managing security, 26.5.3

managing XML schema, 26.6

Oracle Net Services, 1.2.1

Oracle Text

CONTAINS and XMLType, 4.4

creating Oracle Text indexs on XMLType columns, 4.4.5

DBMS_XDBT, F.11

searching XML in CLOBs, 1.5

Oracle XML DB

access models, 2.6

advanced queueing, 1.5

architecture, 1.2

configuring with Enterprise Manager, 26.4

features, 1.3

foldering, 18.1

installation, A.1.1

installing manually, A.1.3

introducing, 1.1

Java applications, 25.1

Repository, 18.2

upgrading, A.2

versioning, 19.1

when to use, 2.2

Oracle XML DB Resource API for Java/JNDI

examples, 22.4

using, 22.2

oracle.xdb, E.1, E.1

oracle.xdb.dom, E.1

oracle.xdb.spi, E.2

XDBResource.getContent(), E.2

XDBResource.getContentType, E.2

XDBResource.getCreateDate, E.2

XDBResource.getDisplayName, E.2

XDBResource.getLanguage(), E.2

XDBResource.getLastModDate, E.2

XDBResource.getOwnerId, E.2

XDBResource.setACL, E.2

XDBResource.setAuthor, E.2

XDBResource.setComment, E.2

XDBResource.setContent, E.2

XDBResource.setContentType, E.2

XDBResource.setCreateDate, E.2

XDBResource.setDisplayName, E.2

XDBResource.setInheritedACL, E.2

XDBResource.setLanguage, E.2

XDBResource.setLastModDate, E.2

XDBResource.setOwnerId, E.2

oracle.xdb.XMLType, 12.4.2.1

ordered collections in tables (OCTs)

default storage of VARRAY, 5.13

rewriting collection index, 5.14.5.1

P

PATH, 20.5

path name

resolution, 18.3.2

PATH_VIEW

structure, 20.1.2

Path-based access

explained, 18.5

PD (Postional Descriptor), 5.7.2

performance

improved using Java writeToStream, 18.5.1.5

PL/SQL DOM

examples, 10.2.13

methods, 10.2.7

PL/SQL Parser for XMLType, F.3

PL/SQL XSLT Processor for XMLType, F.4

point-to-point

support in AQ, 29.1

Positional Descriptor (PD), 5.7.2, 5.7.2

predicates, 5.14.5.1

collection, mapping of, 5.14.5.1

privileges

aggregate, 23.3.2

atomic, 23.3.1

granting from Oracle Enterprise Manager, 26.5.4

processXSL() function, 10.4.5

protocol server

architecture, 24.1.1.2

configuration parameters, 24.2.1

event-based logging, 24.2.4

FTP, 24.3

FTP configuration parameters, 24.2.1

HTTP, 24.4

HTTP/WebDAV configuration parameters, 24.2.1

Oracle XML DB, 24.1

WebDAV, 24.5

protocols

access calling sequence, 18.5.1.2

access to Repository resources, 18.5.1

retrieving resource data, 18.5.1.3

storing resource data, 18.5.1.3

publish/subscribe

support in AQ, 29.1

purchaseorder.xsl, D.5

Q

query access

using RESOURCE_VIEW and PATH_VIEW, 20.1

query rewrite, 5.14

query-based access

using SQL, 18.8

querying

XML data, 4.2

XMLType, 4.2.3

transient data, 4.2.7

R

REF attribute, 6.3, 6.8.2

registerHandler, 17.11.1

Reinstalling

Oracle XML DB

reinstalling, A.1.4

Repository, 18.2

where is the data stored, 18.3.1

resource id

new version, 19.2.2

RESOURCE_VIEW

explained, 20.1

PATH_VIEW differences, 20.1.3

structure, 20.1.1

resources

accessing Repository, 18.4

accessing with protocols, 24.2.2

configuration management, 21.5

controlling access to, 23.3

defined, 18.2.1

deleting, 18.3.2, 18.3.3

deleting non-empty containers, 20.7.3.1

deleting using DELETE, 20.7.3

management using DBMS_XDB, 21.3

multiple simultaneous operations, 20.8

required privileges for operations, 23.3.2

setting property in access control lists (ACLs), 23.5

updating, 20.7.4

S

scalar nodes, mapping, 5.14.5.1

scalar value

converting to XML document using SYS_XMLGEN, 15.11.1

schemaValidate, 8.3.2

searching CLOBs, 1.5

security

aggregate privileges, 23.3.2

DBUri, 17.14.3

management using DBMS_XDB, 21.4

management with Enterprise Manager, 26.5.3

servlets

accessing Repository data, 18.9

and session pooling, 25.6

APIs, 25.8

configuring, 25.9.2

configuring Oracle XML DB, 25.4

DBUri, URL into a query, 17.14

example, 25.9

installing, 25.9.1

session pooling, 25.6

session pooling and Oracle XML DB, 24.1.1.2

testing the, 25.9.3

writing Oracle XML DB HTTP, 25.3

XML manipulation, with, 25.2.3

session pooling, 25.6

protocol server, 24.1.1

setSchemaValidated, 8.3.4

Simple Object Access Protocol (SOAP) and IDAP, 29.5

simpleContent

mapping to object types, 6.6.2

simpleType

elements, B.2.1

mapping to SQL, 5.12

mapping to VARCHAR2, 5.12.1

SOAP

access through Advanced Queueing, 1.2.1

and IDAP, 29.5

SQL functions

existsNode, 4.2.4

SQL*Loader, 27.2

SQLInLine attribute, 6.3

SQLName, 5.9, 5.9

SQLSchema attribute, 5.4.6

SQLType, 5.10.1

attribute, 6.5.2

SQLType attribute, 5.9

SQLX

generating XML, 15.2

generating XML, for, 15.1.1

Oracle extensions, 15.1.2

storage

structured, query rewrite, 5.14

XMLType CREATE TABLE, 5.8.1

structured and unstructured storage, definitions, 5.8

substitution

creating columns by inserting HttpUriType, 17.10.1.1

/sys, restrictions, 18.1

SYS_DBURIGEN, 17.13, 17.13

examples, 17.13.2

inserting database references, 17.13.2

passing columns or attributes, 17.13.1

retrieving object URLs, 17.13.2

returning partial results, 17.13.2

returning Uri-refs, 17.13.2

text function, 17.13.1

SYS_REFCURSOR

generating a document for each row, 15.5

SYS_XDBPD$ attribute, 5.7.2, 5.14.5.2.1, 6.9.2

in query rewrites, 5.14.5

suppressing, 5.7.2

SYS_XMLAgg, 15.12

SYS_XMLGEN, 15.11

converting a UDT to XML, 15.11.1

converting XMLType instances, 15.11.1

object views, 15.11.1

static member function create, 15.11.1

using with object views, 15.11.1

XMLFormat attributes, 15.11.1

XMLGenFormatType object, 15.11.1

T

tableProps attribute, 5.4.7

tablespace

do not drop, A.1.2

transform, 8.1.1

U

UDT

generating an element from, 15.3.1

generating an element using XMLForest, 15.4

UNDER_PATH, 20.3, 20.3

summary, 20.1.4

unstructured and structured storage, definitions, 5.8

updateXML, 6.12

creating views, 4.3.6

mapping NULL values, 4.3.2

updating

resources, 20.7.4

same node more than once, 4.3.3

upgrading

existing installation, A.2

URI

base, C.6.3

UriFactory, 17.11

configuring to handle DBUri-ref, 17.14.4

factory method, 17.11

generating UriType instances, 17.11

registering ecom protocol, 17.11.1

registering new UriType subtypes, 17.11.1

registerURLHandler, 17.11.1

Uri-reference

database and session, 17.6.6

datatypes, 17.3

DBUri, 17.5.1

DBUri and object references, 17.6.5

DBUri syntax guidelines, 17.5.3

DBUri-ref, 17.5

DBUri-ref uses, 17.6.7

explained, 17.2.1

HTTP access for DBUri-ref, 17.14

UriFactory package, 17.11

UriType examples, 17.10.1

UriTypes, 17.10

benefits, 17.3.1

examples, 17.10.1

subtypes, advantages, 17.12

URL

identifying XML schema, 5.2

V

validating

examples, 8.4

isSchemaValid, 8.3.5

isSchemaValidated, 8.3.3

schemaValidate, 8.3.2

SetSchemaValidated, 8.3.4

with XML schema, 5.3.1.2

XMLIsValid, 8.3.1

VCR, 19.2, 19.2.3

access control and security, 19.3

version-controlled resource (VCR), 19.2, 19.2.3

versioning, 1.2.2.2, 19.1

FAQs, 19.4

views

RESOURCE and PATH, 20.1

W

W3C DOM Recommendation, 10.2.4

WebDAV

protocol server, features, 24.5

WebFolder

creating in Windows 2000, 24.5.2

writeToStream, 18.5.1.5

X

XDBBinary, 18.2.1, 18.5.1.3

xdbconfig.xml, 24.1.1.1

XDBUri, 17.2.2

XDBUriType

defined, 17.1

stores references to Repository, 17.3

XML

binary datatypes, 5.12

fragments, mapping to LOBs, 6.5.2

primitive datatypes, 5.12

primitive numeric types, 5.12

XML documents using Java, 12.2.2

accessingwith JDBC, 12.2.3.1

XML loading (lazy manifestation), 10.1.1.1

XML schema

and Oracle XML DB, 5.3

compared to DTD, B.14

complexType declarations, 6.6.1

creating default tables during registration, 5.4.7

cyclical references, 6.13

cyclical references between, 6.13

DTD limitations, B.14.1

elementFormDefault, 5.14.5.1

Enterprise Manager, managing them from, 26.6

features, B.14.2

global, 5.6.2

inheritance in, complexType restrictions, 6.6.1

local, 5.6.1

local and global, 5.6

managing and storing, 5.4.4

mapping to SQL object types, 10.2.5

navigating in Enterprise Manager, 26.6.1

registering, 5.4.1

SQL mapping, 5.10.1

unsupported constructs in query rewrites, 5.14.3.4, 5.14.3.5, 5.14.3.6

updateXML(), 6.12

URLs, 6.5

W3C Recommendation, 3.4, 5.1

XMLType methods, 5.5

XML schema, creating a view in Enterprise Manager, 26.7.6

XML Schema, introducing W3C, B.2

XML SQL Utility

generating XML, 15.14

XML SQL Utility (XSU)

generating XML, 15.1.6

XMLAgg, 15.7

XMLAttributes, 15.3.1

XMLColAttVal, 15.8

XMLConcat, 15.6

concatenating XML elements in argument, 15.6

returning XML elements by concatenating, 15.6

XMLDATA

column, 5.14.5.1

optimizing updates, 5.14.5.2.5, 6.12

parameter, F.1

pseudo-attribute of XMLType, 5.14.1, 6.8.2.1

XMLElement, 15.3

attribute, 15.3.1

generating elements from DTD, 15.3.1

using namespaces to create XML document, 15.3.1

XMLForest, 15.4

generating elements, 15.4

generating elements from DTD, 15.4

XMLFormat

XMLAgg, 15.7

XMLFormat object type

SYS_XMLGEN

XMLFormatType object, 15.11.1

XMLGenFormatType object, 15.11.1

XMLIsValid, 8.3.1

XMLSequence, 15.5

generating an XML document for each row, 15.5

generating one document from another, 15.5

unnesting collections in XML to SQL, 15.5

XMLTransform, 8.1.1

XMLType

API, F.1

benefits, 3.1.2

CONTAINS operator, 4.4

CREATE TABLE, 5.8.1

extracting data, 4.2.7

indexing columns, 4.4

instances, PL/SQL APIs, 10.1

Java

writeToStream, 18.5.1.5

loading data, 27.1

querying, 4.2, 4.2.3

querying transient data, 4.2.7

querying with extractValue() and existsNode(), 4.2.7

querying XMLType columns, 4.2.7

queue payloads, 29.6.1

storage architecture, 1.2.1

summarized, I.1.1

table, querying with JDBC, 12.2.3.1

tables, views, columns, 5.8

views, access with PL/SQL DOM APIs, 10.2.6

Xpath support, 4.4

XMLType, loading with SQL*Loader, 27.2

XPath

basics, D.3

expressions, mapping, 5.14.5.1

mapping for extract(), 5.14.5.2.4, 6.11.1

mapping for extract() without document order, 6.11.2

mapping for extractValue(), 5.14.5.2.2, 6.10

mapping to NULL in, 5.14.5.1

mapping, simple, 5.14.5.1

rewrites for existNode(), 6.9

rewriting expressions, 5.14.3, 5.14.4

support, 4.4

text(), 5.14.5.1

W3C introducing, C.1

XPath expressions

supported, 5.14.3

xsi.noNamespaceSchemaLocation attribute, 5.2

XSL

and CSS, D.4

basics, D.1

XSL style sheet, example, D.5

XSLT, 10.2.7

1.1 specification, D.3

explained, D.2

xsql

include-xml

aggregating results into one XML, 15.13

generating XML from database, 15.13

XSQL Pages Publishing Framework

generating XML, 15.1.5, 15.13