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 entry (ACE)

definition, 27.2.3

access control list (ACL), 27.1

definition, 27.2.4

overview, 1.2.5.2

access privileges, 27.3

account XDB, 2.1, 3.19.1, 3.19.7, 25.5, 25.6, 26.2, 27.1.1, 34.1.4, 36.6.1, 36.6.1

ACE

definition, 27.2.3

ACL

definition, 27.2.4

See access control list

ACLOID resource property

definition, 27.1.1

administering Oracle XML DB, 34

Advanced Queuing (AQ)

hub-and-spoke architecture support, 37.1.2

IDAP, 37.4

message management support, 37.1.3

messaging scenarios, 37.1.1

point-to-point support, 37

publish/subscribe support, 37

XMLType queue payloads, 37.5.1

aggregating generated XML data

XSQL Servlet and SQL function XMLAgg, 17.6

annotations

XML schema, 3.7.3, 6.9

querying to obtain, 6.10

anonymous user, access to repository, 28.2.1

any element, 21.3

appendChildXML SQL function, 4.2.8

attributes

collection (SQL), 6.12.5

columnProps, 6.3.8

Container, 21.3.2

defaultTable, 6.3.8, 6.9.1

in elements, 6.9.3

maintainDOM, 6.6.2, 6.9.1, 7.7.1.2

maintainOrder, 6.9.3

maxOccurs, 6.9.3

namespaces, 6.2

of XMLFormat, 17.4.1

REF, 8.3, 8.9.2

SQLCollType, 6.9.1

SQLInline, 8.3, 8.3

SQLName, 6.9.1

SQLSchema, 6.3.7

SQLType, 6.9.1, 8.6

storeVarrayAsTable, 6.9.1, 6.9.1

sys_DburiGen SQL function, passing to, 20.8.1

SYS_XDBPD$, 6.6.2, 7.5, 7.7.1.2

tableProps, 6.3.8

XMLDATA, 7.1, 8.9.2.1

XMLType, in AQ, 37.5.1

xsi.NamespaceSchemaLocation, 6.1

xsi.noNamespaceSchemaLocation, 19.3.1.1

authenticatedUser role

DBuri servlet security, 20.9.2

B

backward-compatible XML schema evolution

definition, 9.3.1

binary XML

definition, 1.3.3

bind variables

XPath rewrite, 8.11.1

bootstrap ACL

definition, 27.1.1

B-tree index, 1.3.3, 3.16.2, 3.16.4

C

C API for XML, 15

CharacterData interface, 12.2.10

circular dependencies

XML schemas, 8.9

CLASSPATH Java variable

setting, 31.3.1

CLOB storage of XML data

definition, 1.3.3

closeContext PL/SQL procedure, 13.2

collection

in out-of-line tables, 8.4

loading and retrieving large documents, 8.12

collection attribute (SQL), 6.12.5

collection, XML

definition, 6.8.1.3

columnProps attribute, 6.3.8

complex XLink link

definition, 23.2.2

See extended XLink link

complexType

cycling between, 8.9.2

handling inheritance, 8.7.1

mapping

any and anyAttribute declarations, 8.7.3

fragments to LOBs, 8.6

to SQL, 6.12.5

Oracle XML DB restrictions and extensions, 8.7

component of a resource path name

definition, 21.2.1

compound XML document, 23.3

definition, 23.1

configuring Oracle XML DB

protocol server, 28.2.1

repository, 22

servlets, 32.4

using DBMS_XDB API, 34.4.1.8

using Oracle Enterprise Manager, 34.3

xdbconfig.xml configuration file, 34.4

constraints on XMLType data, 6.8.2

repetitive XML elements, 8.2

contains SQL function, 5.2.3.2

contains XPath function (Oracle), 11.5

content of a resource

definition, 21.2.1

Content Repository API for Java

See JCR

content-management application

definition, 23.1

Contents element, 21.3

copy-based schema evolution, 9.2

copyEvolve PL/SQL procedure, 9

CREATE TABLE statement

XMLType storage as CLOB, 6.8.1.2

createXML() XMLType method, 12.1.1.3, 14.2.1

CTXCAT index, 11.4.5.1

CTXRULE index, 11.4.5.1

CURSOR_SHARING

setting to FORCE to enable XPath rewrite, 8.11.1

cyclical dependencies

XML schemas, 8.9

D

data-centric use of XML data

definition, 1.3.3

date

format conversions for XML, 7.5.1.8

mapping to SQL, 6.12.4

DBMS_METADATA PL/SQL package, 20.3.1

reference documentation, 1.2.2, 1.2.2

DBMS_XDB PL/SQL package, 26.1

reference documentation, 1.2.2, 1.2.2

DBMS_XDB_ADMIN PL/SQL package

reference documentation, 1.2.2

DBMS_XDB_VERSION PL/SQL package, 24

reference documentation, 1.2.2

DBMS_XDBT PL/SQL package, 1.2.2

DBMS_XDBZ PL/SQL package, 29.7

disable_hierarchy procedure, 3.16.4.1

enable_hierarchy procedure, 27.4

is_hierarchy_enabled function, 29.7

purgeLDAPCache procedure, 27.8

reference documentation, 1.2.2

DBMS_XEVENT PL/SQL package

reference documentation, 1.2.2

DBMS_XMLDOM PL/SQL package, 12.2

examples, 12.2.12

reference documentation, 1.2.2

DBMS_XMLGEN PL/SQL package, 17.3

reference documentation, 1.2.2

DBMS_XMLINDEX PL/SQL package

reference documentation, 1.2.2

DBMS_XMLPARSER PL/SQL package, 12.3

reference documentation, 1.2.2

DBMS_XMLQUERY PL/SQL package, 1.2.2

DBMS_XMLSAVE PL/SQL package, 13.1

reference documentation, 1.2.2

DBMS_XMLSCHEMA PL/SQL package, 6.3

copyEvolve procedure, 9

deleteSchema procedure, 6.3.12

generateSchema and generateSchemas functions, 8.1

inPlaceEvolve procedure, 9

mapping types, 6.12, 6.13

purgeSchema procedure, 6.3.12.1

reference documentation, 1.2.2

registerSchema procedure, 6.3.1, 8.10.3

enableHierarchy parameter, 29.2

DBMS_XMLSTORE PL/SQL package, 13

reference documentation, 1.2.2

DBMS_XSLPROCESSOR PL/SQL package, 12.4

reference documentation, 1.2.2

DBUri

definition, 20.3

generating using sys_DburiGen SQL function, 20.8

identifying a row, 20.6.4.2

identifying a target column, 20.6.4.3

retrieving column text value, 20.6.4.4

retrieving the whole table, 20.6.4

security, 20.9.2

servlet, installation, 20.9.1

DBUri-refs, 20.6

HTTP access, 20.9

DBUriServlet

definition, 20.9

DBURIType

definition, 20.3

debugging

XML schema registration, 6.3.6

default tables

creating during XML schema registration, 6.3.8

defaultTable attribute, 6.3.8, 6.9.1

deleteSchema PL/SQL procedure, 6.3.12

deleteXML PL/SQL function, 13.1

deleteXML SQL function, 4.2.9

XPath rewrite, 7.7.6

deleting

resource, 25.3.2

XML schema using DBMS_XMLSCHEMA, 6.3.12

depth SQL function, 25.2.4

E

elementFormDefault, 7.5.1.7

elements

any (XML Schema), 21.3

Contents, Resource index, 21.3

XDBBinary, 21.5.1.3

enable_hierarchy PL/SQL procedure, 27.4, 27.4

enableHierarchy parameter, DBMS_XMLSCHEMA.registerSchema, 29.2

Enterprise Manager

administering Oracle XML DB, 34.3

equals_path SQL function, 25.2.2

event handler, repository

definition, 30.1.3

event listener, repository

definition, 30.1.3

evolution, XML schema, 9

existsNode SQL function, 4.1.3.2

dequeuing messages, 2.8.1

XPath rewrite, 7.7.1

EXPLAIN PLAN

using to tune XPath rewrite, 3.16.1

extended XLink link

definition, 23.2.2

extract SQL function, 4.1.3.3

dequeuing messages, 2.8.1

XPath rewrite, 7.7.3, 7.7.3.1

extracting data from XML, 4.1.4

extractValue SQL function, 4.1.3.5

XPath rewrite, 7.7.2

F

fidelity

DOM, 6.6

for XML schema mapping, 12.2.5.1

SYS_XDBPD$ attribute, 6.6.2

using SQL function updateXML, 4.2.3.3

FLWOR XQuery expression, 18.2.3

folder

definition, 21.2.1, 21.2.1

folder link

definition, 21.3.4.1

foldering, 21.1

folder-restricted query

definition, 3.19.13.2

fragment, XML

definition, 3.11.5

SQL operations on, 3.11.5

fragments, XML

mapping to LOBs, 8.6

freeDocument PL/SQL procedure, 12.2.12

freeing a DOMdocument instance, 12.2.12

freeing a temporary CLOB value, 4.1.2

FROM list order

XMLTable PASSING clause, 18.7.4

FTP

configuration parameters, Oracle XMl DB, 28.2.1

creating default tables, 6.3.8

protocol server, features, 28.3

fully qualified XML schema URLs, 8.5

functional evaluation

definition, 3.15

function-based index, 5.3.1, 5.3.2

functions

PL/SQL

deleteXML, 13.1

generateSchema and generateSchemas, 8.1

insertXML, 13.1

is_hierarchy_enabled, 29.7

isSchemaValid, 10.3.5

isSchemaValidated, 10.3.3

updateXML, 13.1

XMLIsValid, 10.3.1

SQL

appendChildXML, 4.2.8

contains, 5.2.3.2

deleteXML, 4.2.9

depth, 25.2.4

equals_path, 25.2.2

existsNode, 4.1.3.2

extract, 4.1.3.3

extractValue, 4.1.3.5

insertChildXML, 4.2.6

insertXMLbefore, 4.2.7

MULTISET and sys_XMLGen, 17.4.1

path, 25.2.3

sys_checkACL, 3.16.4.1

sys_DburiGen, 20.8

sys_XMLAgg, 17.5

sys_XMLGen, 17.4

under_path, 25.2.1

updateXML, 4.2.3

updating XML data, 4.2

XMLAgg, 17.2.5

XMLAttributes, 17.2.1

XMLCast, 4.1.3.4

XMLCDATA, 17.2.12

XMLColAttVal, 17.2.11

XMLComment, 17.2.7

XMLConcat, 17.2.4

XMLElement, 17.2.1

XMLExists, 4.1.3.1

XMLForest, 17.2.2

XMLParse, 17.2.10

XMLPI, 17.2.6

XMLQuery, 18.3, 18.3.1

XMLRoot, 17.2.8

XMLSequence, 17.2.3

XMLSerialize, 17.2.9

XMLTable, 18.3, 18.3.2

XMLtransform, 10.1.1

G

generateSchema and generateSchemas PL/SQL functions, 8.1

generating XML, 17

DBMS_XMLGEN PL/SQL package, 17.3

DBMS_XMLSCHEMA PL/SQL package, 8.1

generateSchema and generateSchemas PL/SQL functions, 8.1

SQL functions, 17.1.2

sys_XMLAgg SQL function, 17.5

sys_XMLGen SQL function, 17.4

XML schemas, 8.1

XML SQL Utility (XSU), 17.7

XMLAgg SQL function, 17.2.5

XMLAttributes SQL function, 17.2.1

XMLCDATA SQL function, 17.2.12

XMLColAttVal SQL function, 17.2.11

XMLComment SQL function, 17.2.7

XMLConcat SQL function, 17.2.4

XMLElement SQL function, 17.2.1

XMLForest SQL function, 17.2.2

XMLParse SQL function, 17.2.10

XMLPI SQL function, 17.2.6

XMLRoot SQL function, 17.2.8

XMLSequence SQL function, 17.2.3

XMLSerialize SQL function, 17.2.9

XSQL Pages Publishing Framework, 17.6

getBLOBVal() XMLType method, 4.1.2, 12.1.1.3, 14.2.1.1

getCLOB() XMLType method, 14.3

getCLOBVal() XMLType method, 4.1.2, 14.2.1.1

freeing temporary CLOB value, 4.1.2

getNamespace() XMLType method, 6.4

getNumberVal() XMLType method, 4.1.2

getObject() XMLType method, 14.2.1.1

getOPAQUE() XMLType method, 14.2.1.1

getRootElement SQL function, 6.4

getRootElement() XMLType method, 6.4

getSchemaURL() XMLType method, 6.4

getStringVal() XMLType method, 4.1.2, 14.2.1.1

getting JCR repository objects, 31.3.2

global element declaration, 31.4.3.4

global XML schema

definition, 6.5.2

using fully qualified URL to override, 8.5

H

hard link

definition, 21.3.4.2

JCR, 31.2.6

hierarchical repository index, 3.19.14

hierarchy-enabled table

definition, 27.4

HTTP

access for DBUri-refs, 20.9

accessing Java servlet or XMLType, 32.2.1

accessing repository resources, 21.5.1.2

configuration parameters, WebDAV, 28.2.1

creating default tables, 6.3.8

improved performance, 28.1.1

Oracle XML DB servlets, 32.5

protocol server, features, 28.4

requests, 32.5

servlets, 32.3

URIFACTORY, 20.9.3

using UriRefs to store pointers, 20.3

HTTPUri

definition, 20.3

HTTPURIType

definition, 20.3

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

hybrid storage

definition, 5.2.1.2

hybrid storage of XML data

definition, 1.3.3

I

IDAP

architecture, 37.5

transmitted over Internet, 37.4

IMPORT/EXPORT

in XML DB, 36.6

index

hierarchical repository, 3.19.14

indexing

CTXCAT, 11.4.5.1

CTXRULE, 11.4.5.1

function-based, 5.3.1, 5.3.2

options for XMLType, 3.1.2

Oracle Text, 1.5, 5.5, 11

XMLType, 5.2

index-organized table (IOT)

definition, 3.7.4

limitations, 3.7.4

inheritance

XML schema, restrictions in complexTypes, 8.7.1

in-place schema evolution, 9.3

inPlaceEvolve PL/SQL procedure, 9

insertChildXML SQL function, 4.2.6

XPath rewrite, 7.7.6

insertXML PL/SQL function, 13.1

insertXML() XMLType method, 14.3

insertXMLbefore SQL function, 4.2.7

installing Oracle XML DB, 34.1

instance document

definition, 1.3.2

specifying root element namespace, 6.1

instance, XML-Schema data type

definition, 8.8

instanceof XPath function (Oracle), 8.8.2

instanceof-only XPath function (Oracle), 8.8.1

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 37.4

IOT

definition, 3.7.4

limitations, 3.7.4

is_hierarchy_enabled PL/SQL function, 29.7

isSchemaBased() XMLType method, 6.4

isSchemaValid PL/SQL function, 10.3.5

isSchemaValid() XMLType method, 6.4

isSchemaValidated PL/SQL function, 10.3.3

isSchemaValidated() XMLType method, 6.4

J

Java

connections, thick and thin, 14.4

DOM API for XMLType, 14.1

Oracle XML DB applications, 32.1

oracle.xml.parser.v2, 14.1

Java Content Repository API

See JCR

JCR

compliance levels supported, 31.3.6

document view serialization

definition, 31.2.3

files and folders, exposure, 31.2.1

getPath method, 31.2.6

hard link, 31.2.6

logging, 31.3.5

Oracle XML DB Repository exposure, 31.2

overview, 31.1.1

restrictions for Oracle XML DB Content Connector, 31.3.7

weak link, 31.2.6

XML schemas, 31.4

JCR node types

mapped to global element declaration, 31.4.3.4

mapping to XML Schema built-in types, 31.4.3.1

mapping to XML Schema simple types, 31.4.3.2, 31.4.3.3

nt:file, 31.2

nt:folder, 31.2

Oracle extensions, 31.2.2

JCR nodes types

generated from XML schemas, 31.4.3

jcr:content, 31.2.5

jcr:data property, 31.2.3

JDBC

accessing XML documents, 14.2.1.1

drivers, thick and thin, 14.2.2

loading large XML documents, 14.3

manipulating XML documents, 14.2.2

JSR-170

See JCR 1.0

L

large node handling, 12.2.13

lazy XML loading (lazy manifestation), 12.1.1.1

link name

definition, 21.2.1

linking

definition, 3.19.13.1

link-properties document

definition, 3.19.13.1

large documents with collections, 8.12

loading large XML documents using JDBC, 14.3

loading of XML data, lazy, 12.1.1.1

LOBs

mapping XML fragments to, 8.6

local XML schema

definition, 6.5.1

using fully qualified URL to specify, 8.5

M

maintainDOM attribute, 6.6.2, 6.9.1, 7.7.1.2

maintainOrder attribute, 6.9.3

manifestation, lazy, 12.1.1.1

mapping

collection predicates, 7.5.1.3

complexType any and anyAttributes declarations, 8.7.3

complexType to SQL, 6.12.5

out-of-line storage, 8.3

overriding using SQLType attribute, 6.12.3.1

predicates (XPath), 7.5.1.3

scalar nodes, 7.5.1.2

simpleContent to object types, 8.7.2

simpleType to SQL, 6.12.4

type information, setting, 6.12.3

matches XQuery function (Oracle), 18.6.2

maxOccurs attribute, 6.9.3

metadata

definition, 29.1

system-defined

definition, 1.2.5

user-defined

definition, 1.2.5

methods

XMLType

createXML(), 12.1.1.3, 14.2.1

getBLOBVal(), 4.1.2, 14.2.1.1

getCLOB(), 14.3

getCLOBVal(), 4.1.2, 14.2.1.1

getNamespace(), 6.4

getNumberVal(), 4.1.2

getObject(), 14.2.1.1

getOPAQUE(), 14.2.1.1

getRootElement(), 6.4

getSchemaURL(), 6.4

getStringVal(), 4.1.2, 14.2.1.1

insertXML(), 14.3

isSchemaBased(), 6.4

isSchemaValid(), 6.4

isSchemaValidated(), 6.4

schemaValidate(), 6.4

setObject(), 14.2.2

setOPAQUE(), 14.2.2

setSchemaValidated(), 6.4

writeToStream(), 21.5.1.5

XML schema, 6.4

MIME

overriding with DBUri servlet, 20.9

mix:referenceable, 31.2.3

mixed XML content

definition, 1.3.3

MULTISET SQL function

use with sys_XMLGen selects, 17.4.1

N

NamedNodeMap object (DOM), 12.2.10

namespace

in XPath, 7.5.1.7

URL for XML schema, 6.1

XQuery, 18.5, 18.7.5

naming SQL objects, 6.9

navigational access to repository resources, 21.5

nested XML

generating using DBMS_XMLGEN, 17.3.3

generating with XMLElement, 17.2.1.3

nested XMLAgg functions and XSQL, 17.6

NESTED_TABLE_ID pseudocolumn, 3.7.7

newDOMDocument() function, 12.2.9

NO_XML_QUERY_REWRITE optimizer hint, 5.4.8

NO_XMLINDEX_REWRITE optimizer hint, 5.4.8

NO_XMLINDEX_REWRITE_IN_SELECT optimizer hint, 5.4.8

node_exists pseudofunction, 7.5.1.9

NodeList object (DOM), 12.2.10

nodes, large (DBMS_XMLDOM), 12.2.13

nodes, large (Java), 14.6

non-schema-based view

definition, 19.1

nt:file JCR node type, 31.2

nt:folder, 31.2

nt:folder JCR node type, 31.2

NULL

XPath mapping to, 7.5.1.6

O

object identifier

definition, 27.1.1

OBJECT_ID column of XDB$ACL table, 27.1.1

object-based persistence of XML data

definition, 1.3.3

object-relational storage of XML data

definition, 1.3.3

occurrence indicator

definition, 18.2.2

OCI API for XML, 15

ocjr prefix, 31.2.2

OCT

definition, 3.7.4

ODP.NET, 16

OID

See object identifier

ojcr:folder, 31.2.3

operator

See functions, SQL

optimizer hints, 5.4.8

ora:contains XPath function (Oracle), 11.5

policy

definition, 11.5.4

ora:instanceof XPath function (Oracle), 8.8.2

ora:instanceof-only XPath function (Oracle), 8.8.1

ora:matches XQuery function (Oracle), 18.6.2

ora:replace XQuery function (Oracle), 18.6.3

ora:sqrt XQuery function (Oracle), 18.6.4

ora:view XQuery function (Oracle), 18.6.5

Oracle Data Provider for .NET, 16

Oracle Enterprise Manager

administering Oracle XML DB, 34.3

Oracle extensions to JCR node types, 31.2.2

Oracle Internet Directory, 27.7

Oracle Net Services, 1.2.1

Oracle Text

contains SQL function and XMLType, 5.2.3.2

index, 1.5, 5.5, 11

searching for resources, 25.6

searching XML in CLOB instances, 1.5

Oracle XML DB

access models, 2.6

advanced queueing, 1.5

architecture, 1.2

features, 1.3

installation, 34.1

introducing, 1.1

Java applications, 32.1

Repository

See repository

upgrading, 34.2

versioning, 24

when to use, 2.2

Oracle XML DB Content Connector, 31

how to use, 31.3

logging API, 31.3.5

overview, 31.1.2

restrictions, 31.3.7

sample code to upload file, 31.3.3

P

partial update of XML data

definition, 4.2.2

partial validation of XML data

definition, 3.9.1.1

PASSING clause of XMLTable

FROM list order, 18.7.4

path component of a resource path name

definition, 21.2.1

path index of XMLIndex

definition, 5.4.3

path name

definition, 21.2.1

resolution, 21.3.2

path SQL function, 25.2.3

path table of XMLIndex, 5.4.3

PATH_VIEW, 25

path-based access to repository resources, 21.5

path-index trigger

definition, 27.4

PD (positional descriptor), 6.6.2

persistence models of XML data, 1.3.3

PL/SQL functions

See functions, PL/SQL

PL/SQL packages

DBMS_METADATA, 20.3.1

reference documentation, 1.2.2, 1.2.2

DBMS_XDB, 26.1

reference documentation, 1.2.2, 1.2.2

DBMS_XDB_ADMIN

reference documentation, 1.2.2

DBMS_XDB_VERSION, 24

reference documentation, 1.2.2

DBMS_XDBT, 1.2.2

DBMS_XDBZ, 27.4, 29.7

reference documentation, 1.2.2

DBMS_XEVENT

reference documentation, 1.2.2

DBMS_XMLDOM, 12.2

reference documentation, 1.2.2

DBMS_XMLGEN, 17.3

reference documentation, 1.2.2

DBMS_XMLINDEX

reference documentation, 1.2.2

DBMS_XMLPARSER, 12.3

reference documentation, 1.2.2

DBMS_XMLQUERY, 1.2.2

DBMS_XMLSAVE, 13.1

reference documentation, 1.2.2

DBMS_XMLSCHEMA

reference documentation, 1.2.2

See DBMS_XMLSCHEMA PL/SQL package

DBMS_XMLSTORE, 13

reference documentation, 1.2.2

DBMS_XSLPROCESSOR, 12.4

reference documentation, 1.2.2

for XMLType, 12.1

PL/SQL procedures

See procedures, PL/SQL

point-to-point

support in AQ, 37

policy for ora:contains XPath function (Oracle)

definition, 11.5.4

ports

configuring

FTP, 28.2.1

HTTP, 28.2.1

HTTPS, 28.2.2

positional descriptor (PD), 6.6.2

post-parse persistence of XML data

definition, 1.3.3

predicates, XPath

mapping to SQL, 7.5.1.3

collection, 7.5.1.3

preference, Oracle Text indexing

definition, 11.4.5.1

prefix ocjr, 31.2.2

pretty-printing

in book examples, Preface

not done by SQL/XML functions, 3.17

principal, access control

definition, 27.2.1

private (local) XML schema, definition, 6.5

privilege, access control

definition, 27.2.2

privileges, access, 27.3

procedures

PL/SQL

closeContext, 13.2

copyEvolve, 9

disable_hierarchy, 3.16.4.1

enable_hierarchy, 27.4, 27.4

freeDocument, 12.2.12

inPlaceEvolve, 9

processXSL, 12.4.3

purgeLDAPCache, 27.8

registerSchema, 6.3.1

schemaValidate, 10.3.2

setKeyColumn, 13.2

setSchemaValidated, 10.3.4

setUpdateColumn, 13.2

processXSL PL/SQL procedure, 12.4.3

protocol server, 28.1

architecture, 28.1.1

configuration parameters, 28.2.1

event-based logging, 28.2.5

FTP, 28.3

configuration parameters, 28.2.1

HTTP, 28.4

configuration parameters, 28.2.1

WebDAV, 28.5

configuration parameters, 28.2.1

protocols, access to repository resources, 21.5.1

public (global) XML schema, definition, 6.5

publish/subscribe

support in AQ, 37

purchase-order XML document, 4.1.3.3

used in full-text examples, 11.7.1

purchase-order XML schema, 3.6.4.1

annotated, 3.7.5, A.6

graphical representation, 3.6.4.2

revised, 9.2.1, A.6

purgeLDAPCache PL/SQL procedure, 27.8

purgeSchema PL/SQL procedure, 6.3.12.1

Q

qualified XML schema URLs, 8.5

query-based access to resources

using RESOURCE_VIEW and PATH_VIEW, 25.1

using SQL, 21.6

querying XMLType data

choices, 4.1

transient data, 4.1.4

R

RAC

updating xdbconfig.xml, 34.4

recursive schema support, 8.10

REF reference attribute, 8.3, 8.9.2

REGISTER_AUTO_OOL option for XML schema registration, 3.7.6.2, 6.3.1

REGISTER_NT_AS_IOT option for XML schema registration, 3.7.4, 3.7.4, 6.3.1

registered XML schemas, list of, 6.3.11

registering an XML schema, 6.3.1

debugging, 6.3.6

default tables, creating, 6.3.8

SQL object types, creating, 6.3.7

registerSchema PL/SQL procedure, 6.3.1

reinstalling Oracle XML DB, 34.1.4

renaming an XMLIndex index, 5.4.5

replace XQuery function (Oracle), 18.6.3

repository, 21.2

access by anonymous user, 28.2.1

data storage, 21.3.1

event handler

definition, 30.1.3

event listener

definition, 30.1.3

hierarchical index, 3.19.14

resource

See resource

use with XQuery, 18.7.2

repository link

definition, 21.3.4.1

repository objects, 31.3.2

resource

access, 21.4

controlling, 27.3

using protocols, 28.2.3

definition, 1.2.5, 29.1

deleting, 21.3.4.2

nonempty container, 25.3.2.1

using DELETE, 25.3.2

managing with DBMS_XDB, 26.2

required privileges for operations, 27.3.2

searching for, using Oracle Text, 25.6

setting property in ACLs, 27.5

simultaneous operations, 25.4

updating, 25.3.3

resource configuration file

definition, 22.1

resource configuration list

definition, 22.1

resource content

definition, 21.2.1

resource document

definition, 3.19.7

resource id

new version, 24.2.2

resource name

definition, 21.2.1

RESOURCE_VIEW

explained, 25

resource-view-cache-size configuration parameter, 25.5

retrieving large documents with collections, 8.12

rewrite

XPath (XPath), 7

XQuery, 18.8

role XDB_SET_INVOKER, 30.5.1

role XDBADMIN, 5.4.10.1, 5.4.10.4, 6.5.2, 22.1, 27.1.1, 30.5, 30.5, 30.5.1

root XML Schema

definition, 6.3.5

S

scalar nodes, mapping, 7.5.1.2

scalar value

converting to XML document using sys_XMLGen, 17.4.1

schema evolution, 9

copy-based, 9.2

in-place, 9.3

schema location hint

definition, 3.7.6

schemaValidate PL/SQL procedure, 10.3.2

schemaValidate() XMLType method, 6.4

searching CLOB instances, 1.5

security

DBUri, 20.9.2

semi-structured XML data

definition, 1.3.3

servlets

accessing repository data, 21.7

APIs, 32.8

configuring, 32.4

installing, 32.9.1

session pooling, 32.6, 32.6

testing, 32.9.3

writing, 32.9

in Java, 32.3

XML manipulation, 32.2.3

session pooling, 32.6

protocol server, 28.1.1

setKeyColumn PL/SQL procedure, 13.2

setObject() XMLType method, 14.2.2

setOPAQUE() XMLType method, 14.2.2

setSchemaValidated PL/SQL procedure, 10.3.4

setSchemaValidated() XMLType method, 6.4

setUpdateColumn PL/SQL procedure, 13.2

simple XLink link

definition, 23.2.2

simpleContent

mapping to object types, 8.7.2

simpleType

mapping to SQL, 6.12.4

SOAP

access through Advanced Queueing, 1.2.1

IDAP, 37.4

SQL function

See functions, SQL

SQL functions

getRootElement, 6.4

See functions, SQL

SQL object types

creating during XML schema registration, 6.3.7

SQL operator

See functions, SQL

SQL*Loader, 35.2

SQL*Plus

XQUERY command, 18.10

SQLCollType attribute, 6.9.1

SQLInline attribute, 8.3

SQLJ, 14.4.1.1

SQLName attribute, 6.9.1

SQLSchema attribute, 6.3.7

SQLType attribute, 6.9.1, 8.6

SQL/XML standard, 3.17

generating XML data, 17.2

sqrt XQuery function (Oracle), 18.6.4

standard metadata, 31.2.4

static type-checking

XQuery language, 18.9

storage

out of line, 8.3

collections, 8.4

XMLType, CREATE TABLE, 6.8.1.2

storage models of XML data, 1.3.3

storeVarrayAsTable attribute, 6.9.1, 6.9.1

string, XML

mapping to VARCHAR2, 6.12.4.2

structured storage of XML data

definition, 1.3.3

style sheet for updating existing XML instance documents, 9.2.5

subtype of an XML-Schema data type

definition, 8.8

sys_checkACL SQL function, 3.16.4.1

sys_DburiGen SQL function, 20.8

inserting database references, 20.8.2

retrieving object URLs, 20.8.2, 20.8.2

returning partial results, 20.8.2

use with text node test, 20.8.1

SYS_NC_ARRAY_INDEX$ column, 3.7.7

SYS_XDBPD$ attribute, 6.6.2, 7.7.1.2

XPath rewrite, 7.5

sys_XMLAgg SQL function, 17.5

sys_XMLGen SQL function, 17.4

converting a UDT to XML, 17.4.1

converting XMLType instances, 17.4.1

object views, 17.4.1

XMLFormat attributes, 17.4.1

XMLGenFormatType object, 17.4.1

system-defined metadata

definition, 1.2.5

T

tableProps attribute, 6.3.8

tablespace

do not drop, 34.1.2

temporary CLOB value, freeing, 4.1.2

text-based persistence of XML data

definition, 1.3.3

third-party XLink link

definition, 23.2.2

trigger, path-index

definition, 27.4

type-checking, static and dynamic

XQuery language, 18.9

U

UDT

generating an element from, 17.2.1.3

under_path SQL function, 25.2.1

unique constraint on parent element of an attribute, 8.2

unresolved XLink and XInclude links, 23.7.1

unstructured storage of XML data

definition, 1.3.3

updateXML PL/SQL function, 13.1

updateXML SQL function, 4.2.3

mapping NULL values, 4.2.3.1

XPath rewrite, 7.7.5

updating repository resource, 25.3.3

updating XML data

partial update

definition, 4.2.2

to create XML views with different data, 4.2.5

updating same node more than once, 4.2.3.2

using SQL functions, 4.2

optimization, 4.2.4

upgrading Oracle XML DB, 34.2

URIFACTORY PL/SQL package

configuring to handle DBURI-ref, 20.9.3

creating subtypes of URIType, 20.7

Uri-reference

database and session, 20.6.3

DBUri-ref, 20.6

HTTP access for DBUri-ref, 20.9

URIFACTORY PL/SQL package, 20.7

URIType examples, 20.4

URIType

examples, 20.4

user XDB, 2.1, 3.19.1, 3.19.7, 25.5, 25.6, 26.2, 27.1.1, 34.1.4, 36.6.1, 36.6.1

user-defined metadata, 31.2.5

definition, 1.2.5

V

validating

examples, 10.4

isSchemaValid PL/SQL function, 10.3.5

isSchemaValidated PL/SQL function, 10.3.3

schemaValidate PL/SQL procedure, 10.3.2

setSchemaValidated PL/SQL procedure, 10.3.4

XMLIsValid PL/SQL function, 10.3.1

validation of XML data, partial

definition, 3.9.1.1

value index of XMLIndex

definition, 5.4.3

varray in a LOB

definition, 3.7.4

varray in a table

definition, 3.7.4

VCR

See version-controlled resource

version-controlled resource (VCR), 24.2, 24.2.3

access control and security, 24.3

definition, 24.1.2

versioning, 1.2.5.2, 24

view XQuery function (Oracle), 18.6.5

views

RESOURCE and PATH, 25

W

weak link

definition, 21.3.4.2

deletion, 23.7.1

JCR, 31.2.6

WebDAV protocol server, 28.5

WebFolder

creating in Windows 2000, 28.5.3

well-formed XML document

definition, 3.9

writeToStream() XMLType method, 21.5.1.5

X

XDB database schema (user account), 2.1, 3.19.1, 3.19.7, 25.5, 25.6, 26.2, 27.1.1, 34.1.4, 36.6.1, 36.6.1

XDB$ACL table, 27.1.1

XDB_SET_INVOKER role, 30.5.1

XDBADMIN role, 5.4.10.1, 5.4.10.4, 6.5.2, 22.1, 27.1.1, 27.1.1, 30.5, 30.5, 30.5.1

XDBBinary element, 21.5.1.3

definition, 21.2.1

xdbconfig.xml configuration file, 34.4

xdbcore parameters, 8.12.1

xdbcore-loadableunit-size configuration parameter, 8.12, 25.5

xdbcore-xobmem-bound configuration parameter, 8.12, 25.5

XDBUri, 20.3.1

definition, 20.3, 20.5

XDBURIType

definition, 20.3

using constructor to expand compound documents (XInclude), 23.5.1

using constructor to expand compound docuuments (XInclude), 23.5.1

XInclude, 23, 23

definition, 23.1

unresolved link, 23.7.1

XLink, 23, 23

complex link

definition, 23.2.2

definition, 23.1

extended link

definition, 23.2.2

link types, 23.2.2

simple link

definition, 23.2.2

third-party link

definition, 23.2.2

unresolved link, 23.7.1

XML

binary data types, 6.12.4

fragments, mapping to LOBs, 8.6

primitive data types, 6.12.4

numeric, 6.12.4

XML DB Repository exposed in JCR, 31.2

XML fragment

definition, 3.11.5

SQL operations on, 3.11.5

XML Object (XOB), 2.10.2

XML publishing functions, SQL/XML, 17.2

XML Schema

definition, Preface

XML schema

annotations, 3.7.3, 6.9

querying to obtain, 6.10

circular dependencies, 8.9

complexType declarations, 8.7.1

cyclical dependencies, 8.9

definition, 6.1

definition (instance document), 1.3.2

deleteXML SQL function

XPath rewrite, 7.7.6

deleting, 6.3.12

elementFormDefault, 7.5.1.7

evolution, 9

for XML schemas, 6.3.5

generating from object-relational type, 8.1

guidelines for use with Oracle XML DB, 8.11

inheritance in, complexType restrictions, 8.7.1

local and global, 6.5

managing and storing, 6.3.5

mapping to SQL object types, 12.2.5

Oracle XML DB, 6.2

registering, 6.3.1, 6.3.1

registration for use with JCR, 31.4.1

updateXML SQL function

XPath rewrite, 7.7.5, 7.7.6

updating after registering, 9

URLs, 8.5

W3C Recommendation, 3.6, 6

XMLType methods, 6.4

XML Schema built-in types

mapping to JCR node types, 31.4.3.1

XML schema evolution

backward-compatible evolution

definition, 9.3.1

XML Schema global element declaration, 31.4.3.4

XML Schema simple types

mapping to JCR node types, 31.4.3.2, 31.4.3.3

XML schema-based tables and columns, creating, 6.8

XML schema-based view

definition, 19.1

XML schemas

generating JCR node types, 31.4.3

use with JCR, 31.4

XML SQL Utility (XSU), generating XML, 17.7

XML string

mapping to VARCHAR2, 6.12.4.2

XML_DB_EVENTS parameter, 30.5

XMLAgg SQL function, 17.2.5

XMLAttributes SQL function, 17.2.1

XMLCast SQL function, 4.1.3.4

XMLCDATA SQL function, 17.2.12

XMLColAttVal SQL function, 17.2.11

XMLComment SQL function, 17.2.7

XMLConcat SQL function, 17.2.4

XMLDATA

column, 7.5.1.2

optimizing updates, 7.7

pseudo-attribute of XMLType, 7.1, 8.9.2.1

XMLElement SQL function, 17.2.1

XMLExists SQL function, 4.1.3.1

XMLForest SQL function, 17.2.2

XMLFormat

XMLAgg, 17.2.5

XMLFormat object type

sys_XMLGen

XMLFormatType object, 17.4.1

XMLGenFormatType object, 17.4.1

XMLIndex

creating index, 5.4.5

dropping index, 5.4.5

order index

definition, 5.4.3

path index

definition, 5.4.3

path table, 5.4.3

renaming index, 5.4.5

value index

definition, 5.4.3

XMLIsValid PL/SQL function, 10.3.1

XMLParse SQL function, 17.2.10

XMLPI SQL function, 17.2.6

XMLQuery SQL function, 18.3, 18.3.1

XMLRoot SQL function, 17.2.8

XMLSequence SQL function, 17.2.3

XMLSerialize SQL function, 17.2.9

XMLTable SQL function, 18.3, 18.3.2

breaking up an XML fragment, 3.11.5

breaking up multiple levels of XML data, 3.12.2

PASSING clause and FROM list order, 18.7.4

XMLtransform SQL function, 10.1.1

XMLType

as abstract data type, 1.3.3

benefits, 3.1.2

constructors, 3.4.1

contains SQL function, 5.2.3.2

CREATE TABLE statement, 6.8.1.2

DBMS_XMLDOM PL/SQL API, 12.2

DBMS_XMLPARSER PL/SQL API, 12.3

DBMS_XSLPROCESSOR PL/SQL API, 12.4

definition, 1.3.1

extracting data, 4.1.4

indexing columns, 5.2

instances, PL/SQL APIs, 12.1

loading data, 35.1

loading with SQL*Loader, 35.2

methods

createXML(), 12.1.1.3, 14.2.1

getBLOBVal(), 4.1.2, 14.2.1.1

getCLOB(), 14.3

getCLOBVal(), 4.1.2, 14.2.1.1

getNamespace(), 6.4

getNumberVal(), 4.1.2

getObject(), 14.2.1.1

getOPAQUE(), 14.2.1.1

getRootElement(), 6.4

getSchemaURL(), 6.4

getStringVal(), 4.1.2, 14.2.1.1

insertXML(), 14.3

isSchemaBased(), 6.4

isSchemaValid(), 6.4

isSchemaValidated(), 6.4

schemaValidate(), 6.4

setObject(), 14.2.2

setOPAQUE(), 14.2.2

setSchemaValidated(), 6.4

writeToStream(), 21.5.1.5

XML schema, 6.4

PL/SQL packages, 12.1

querying, 4.1

querying transient data, 4.1.4

querying with extractValue and existsNode, 4.1.4

querying XMLType columns, 4.1.4

queue payloads, 37.5.1

storage architecture, 1.2.1

storage models, 1.3.3

table, querying with JDBC, 14.2.1.1

tables, views, columns, 6.8

views, access with PL/SQL DOM APIs, 12.2.6

Xpath support, 5.2

XOB, 2.10.2

XPath

functions

ora:contains (Oracle), 11.5

ora:instanceof (Oracle), 8.8.2

ora:instanceof-only (Oracle), 8.8.1

Oracle extension functions, 8.8

support, 5.2

syntax, 4.1.1

text() node test, 7.5.1.2

XPath rewrite, 7, 7

bind variables, 8.11.1

deleteXML SQL function, 7.7.6

existsNode SQL function, 7.7.1

extract SQL function, 7.7.3.1

extractValue SQL function, 7.7.2

indexes on singleton elements and attributes, 5.3.2.1

insertChildXML SQL function, 7.7.6

mapping types and paths, 7.5.1

out-of-line storage, 8.3.1

setting CURSOR_SHARING to FORCE, 8.11.1

to NULL, 7.5.1.6

updateXML SQL function, 7.7.5

using EXPLAIN PLAN to tune, 3.16.1

XQUERY command, SQL*Plus, 18.10

XQuery language, 18

expressions, 18.2.2

FLWOR, 18.2.3

rewrite, 18.8

functions

ora:contains (Oracle), 18.6.1

ora:matches (Oracle), 18.6.2

ora:replace (Oracle), 18.6.3

ora:sqrt (Oracle), 18.6.4

ora:view (Oracle), 18.6.5

item

definition, 18.2.1

namespaces, 18.5, 18.7.5

optimization, 18.8

Oracle extension functions, 18.6

Oracle XML DB support, 18.12

performance, 18.8

predefined namespaces and prefixes, 18.5

referential transparency

definition, 18.2.1

sequence

definition, 18.2.1

SQL*Plus XQUERY command, 18.10

tuning, 18.8

type-checking, static and dynamic, 18.9

unordered mode

definition, 18.2.1

use with ora:view, 18.7.3

optimization, 18.8.1

use with Oracle XML DB Repository, 18.7.2

use with XMLType relational data, 18.7.4

optimization, 18.8.2

XMLQuery and XMLTable SQL functions, 18.3

examples, 18.7

xsi.noNamespaceSchemaLocation attribute, 6.1

XSL style sheet

definition, 12.4

XSLT

style sheet for updating existing XML instance documents, 9.2.5

style sheets

use with DBUri servlet, 3.20.1, 3.21

use with Oracle XML DB, 3.18

use with package DBMS_XSLPROCESSOR, 12.4.3

XSQL Pages Publishing Framework

generating XML, 17.1.4, 17.6

XSU, generating XML, 17.7