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 list (ACL), 24.1

default, 24.2

definition, 1.2.5, 20.2.1

summary, 1.2.5.2

access privileges, 24.3

ACL

See access control list

ACLOID resource property

definition, 24.1.1

Advanced Queuing (AQ)

hub-and-spoke architecture support, 31.1.2

IDAP, 31.4

message management support, 31.1.3

messaging scenarios, 31.1.1

point-to-point support, 31

publish/subscribe support, 31

XMLType queue payloads, 31.5.1

aggregating generated XML data

XSQL Servlet and SQL function XMLAgg, 16.6

annotations

XML schema, 3.6.3, 5.8

querying to obtain, 5.9

anonymous user, access to repository, 25.2.1

any, 20.3

appendChildXML SQL function, 4.2.8

attributes

collection (SQL), 5.12

columnProps, 5.3.8

Container, 20.3.2

defaultTable, 5.3.8, 5.8

in elements, 5.8

maintainDOM, 5.6.2, 5.8, 6.7.1.2

maintainOrder, 5.12

maxOccurs, 5.12

namespaces, 5.2

of XMLFormat, 16.4.1

passing to sys_DburiGen SQL function, 19.8.1

REF, 7.3, 7.9.2

SQLCollType, 5.8

SQLInline, 7.3, 7.3

SQLName, 5.8, 5.9.1

SQLSchema, 5.3.7

SQLType, 5.8, 5.9.1, 7.6

storeVarrayAsTable, 5.8

SYS_XDBPD$, 5.6.2, 6.5, 6.7.1.2

tableProps, 5.3.8

XMLDATA, 6.1, 7.9.2.1

XMLType, in AQ, 31.5.1

xsi.NamespaceSchemaLocation, 5.1

xsi.noNamespaceSchemaLocation, 18.3.1.1

authenticatedUser role

DBuri servlet security, 19.9.2

B

B*Tree index, 1.2.1, 3.1.5

on a collection, 4.3.2

bind variables

XPath rewrite, 7.10.1

C

C API for XML, 14

cascading style sheets, C.4

catalog views, 1.2.3

character sets

importing and exporting XML data, 30.7

CharacterData, 11.2.10

circular dependencies among XML schemas, 7.9

CLOB-based storage

definition, 4.3.4.8

collection attribute (SQL), 5.12

collections

in out-of-line tables, 7.4

loading and retrieving large documents, 7.12

columnProps attribute, 5.3.8

complexType

cycling between, 7.9.2

elements, A.2.1

handling inheritance, 7.7.1

in XML schema, introduction, A.14.2

mapping

any and anyAttribute declarations, 7.7.3

fragments to LOBs, 7.6

to SQL, 5.12

Oracle XML DB extensions, 7.7

Oracle XML DB restrictions, 7.7

configuring

Oracle XML DB, 28.4

using DBMS_XDB API, 28.4.1.8

protocol server in Oracle XML DB, 25.2.1

servlets, 27.4, 27.9.2

constraints on XMLType data, 5.7.3

repetitive XML elements, 7.11

contains SQL function, 4.3

contains XPath function (Oracle), 10.5

content fidelity, 2.9

content of a resource

definition, 20.2.1

Contents element, 20.3

copyevolve PL/SQL procedure, 8

CREATE TABLE statement

XMLType storage, 5.7.1

createXML() XMLType method, 11.1.1.3

CSS and XSL, C.4

CTXCAT index, 10.4.5.1

CTXRULE index, 10.4.5.1

CTXXPATH index, 4.3.4, 10.5.6.2

storage preferences, 4.3.4.3

CURSOR_SHARING

setting to FORCE to enable XPath rewrite, 7.10.1

cyclical dependencies among XML schemas, 7.9

D

date

format conversions for XML, 6.5.1.8

mapping to SQL, 5.11

DBMS_METADATA PL/SQL package, 19.3.1

DBMS_XDB PL/SQL package, 23

DBMS_XDB_VERSION PL/SQL package, 21

DBMS_XMLDOM PL/SQL package, 11.2

pretty-printing, 4.1.1

DBMS_XMLGEN PL/SQL package, 16.3

DBMS_XMLPARSER PL/SQL package, 11.3

DBMS_XMLSCHEMA PL/SQL package

copyevolve procedure, 8

deleteSchema procedure, 5.3.12

generateSchema and generateSchemas functions, 7.1

managing XML schemas, 5.3

mapping types, 5.10

registerSchema enableHierarchy parameter, 26.2

registerSchema procedure, 5.3.1

DBMS_XMLSTORE PL/SQL package, 12

DBMS_XSLPROCESSOR PL/SQL package, 11.4

pretty-printing, 4.1.1

DBUri

definition, 19.3

generating using sys_DburiGen SQL function, 19.8

identifying a row, 19.6.4.2

identifying a target column, 19.6.4.3

retrieving column text value, 19.6.4.4

retrieving the whole table, 19.6.4

security, 19.9.2

servlet, installation, 19.9.1

DBUri-refs, 19.6

HTTP access, 19.9

DBURIType

definition, 19.3

debugging

XML schema registration, 5.3.6

default tables

creating during XML schema registration, 5.3.8

defaultTable attribute, 5.3.8, 5.8

deleteSchema PL/SQL procedure, 5.3.12

deleteXML SQL function, 4.2.9

XPath rewrite, 6.7.6

deleting

resource, 22.3.2

XML schema using DBMS_XMLSCHEMA, 5.3.12

depth SQL function, 22.2.4

E

element, path

definition, 20.2.1

elementFormDefault, 6.5.1.7

elements

any (XML Schema), 20.3

complexType, A.2.1

Contents, Resource index, 20.3

simpleType, A.2.1

XDBBinary, 20.5.1.3

enableHierarchy parameter, DBMS_XMLSCHEMA.registerSchema, 26.2

equals_path SQL function, 22.2.2

evolution, XML schema, 8

existsNode SQL function, 4.1.5

definition, 1.3.5

dequeuing messages, 2.8.1

XPath rewrite, 6.7.1

EXPLAIN PLAN

using to tune XPath rewrite, 3.15.1

exporting XML table, 30.3

extract SQL function, 4.1.6

definition, 1.3.5

dequeing messages, 2.8.1

XPath rewrite, 6.7.3, 6.7.3.1

extracting data from XML, 4.1.8

extractValue SQL function, 4.1.7

definition, 1.3.5

XPath rewrite, 6.7.2

F

fidelity

DOM, 5.6

for XML schema mapping, 11.2.5.1

SYS_XDBPD$ attribute, 5.6.2

using SQL function updateXML, 4.2.3.3

textual (document), 2.9

FLWOR XQuery expression, 17.2.3

folder

definition, 20.2.1, 20.2.1

foldering, 20.1

folder-restricted query

definition, 3.18.13.2

FORCE mode option, 5.3.12.1

fragments, XML

mapping to LOBs, 7.6

freeing a temporary CLOB value, 4.1.3

FTP

configuration parameters, Oracle XMl DB, 25.2.1

creating default tables, 5.3.8

protocol server, features, 25.3

fully qualified XML schema URLs, 7.5

functional evaluation

definition, 3.14

function-based index, 4.3.3

functions

member

See methods

PL/SQL

generateSchema and generateSchemas, 7.1

isSchemaValid, 9.3.5

isSchemaValidated, 9.3.3

XMLIsValid, 9.3.1

SQL

appendChildXML, 4.2.8

contains, 4.3

deleteXML, 4.2.9

depth, 22.2.4

equals_path, 22.2.2

existsNode, 4.1.5

extract, 4.1.6

extractValue, 4.1.7

insertChildXML, 4.2.6

insertXMLbefore, 4.2.7

MULTISET and sys_XMLGen, 16.4.1

path, 22.2.3

sys_DburiGen, 19.8

sys_XMLAgg, 16.5

sys_XMLGen, 16.4

under_path, 22.2.1

updateXML, 4.2.3

XMLAgg, 16.2.5

XMLAttributes, 16.2.1

XMLCDATA, 16.2.12

XMLColAttVal, 16.2.11

XMLComment, 16.2.7

XMLConcat, 16.2.4

XMLElement, 16.2.1

XMLForest, 16.2.2

XMLParse, 16.2.10

XMLPI, 16.2.6

XMLQuery, 17.3

XMLRoot, 16.2.8

XMLSequence, 16.2.3

XMLSerialize, 16.2.9

XMLTable, 17.3, 17.3.2

XMLtransform, 9.1.1

G

generating XML

DBMS_XMLGEN, 16.3

one document from another, 16.2.3

SQL functions, 16.1.2

sys_XMLAgg SQL function, 16.5

sys_XMLGen SQL function, 16.4

XML schema

DBMS_XMLSCHEMA.generateSchema and generateSchemas PL/SQL functions, 7.1

XML SQL Utility (XSU), 16.7

XMLAgg SQL function, 16.2.5

XMLAttributes SQL function, 16.2.1

XMLCDATA SQL function, 16.2.12

XMLColAttVal SQL function, 16.2.11

XMLComment SQL function, 16.2.7

XMLConcat SQL function, 16.2.4

XMLElement SQL function, 16.2.1

XMLForest SQL function, 16.2.2

XMLParse SQL function, 16.2.10

XMLPI SQL function, 16.2.6

XMLRoot SQL function, 16.2.8

XMLSequence SQL function, 16.2.3

XMLSerialize SQL function, 16.2.9

XSQL Pages Publishing Framework, 16.6

getBlobVal() XMLType method, 4.1.3, 11.1.1.3, 13.2

getClobVal() XMLType method, 4.1.3

freeing temporary CLOB value, 4.1.3

getNamespace() XMLType method, 5.4

getNumberVal() XMLType method, 4.1.3

getRootElement() XMLType method, 5.4

getSchemaURL() XMLType method, 5.4

getStringVal() XMLType method, 4.1.3

global XML schema

definition, 5.5.2

using fully qualified URL to override, 7.5

H

hierarchical index (repository), 3.18.14

HTTP

access for DBUri-refs, 19.9

accessing Java servlet or XMLType, 27.2.1

accessing repository resources, 20.5.1.2

configuration parameters, WebDAV, 25.2.1

creating default tables, 5.3.8

improved performance, 25.1.1

Oracle XML DB servlets, 27.5

protocol server, features, 25.4

requests, 27.5

servlets, 27.3

URIFACTORY, 19.9.3

using UriRefs to store pointers, 19.3

HTTPUri

definition, 19.3

HTTPURIType

definition, 19.3

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

hybrid data

See semistructured data

I

IDAP

architecture, 31.5

transmitted over Internet, 31.4

IMPORT/EXPORT

in XML DB, 30.5

index

hierarchical (repository), 3.18.14

indexing

B*Tree, 1.2.1, 3.1.5

on a collection, 4.3.2

CTXCAT, 10.4.5.1

CTXRULE, 10.4.5.1

CTXXPATH, 4.3.4, 10.5.6.2

function-based, 4.3.3

options for XMLType, 3.1.2

Oracle Text, 1.5, 4.3.5, 10

XMLType, 4.3

index-organized table (IOT)

no Oracle Text support, 3.6.7

Information Set

W3C introducing XML, B.6

inheritance

XML schema, restrictions in complexTypes, 7.7.1

insertChildXML SQL function, 4.2.6, 4.2.6, 4.2.7, 4.2.8, 4.2.9

XPath rewrite, 6.7.6

insertXMLbefore SQL function, 4.2.7

installing Oracle XML DB, 28.1

instance document

definition, 1.3.2

specifying root element namespace, 5.1

XML, described, A.14.2

instance, XML Schema datatype

definition, 7.8

instanceof XPath function (Oracle), 7.8.2

instanceof-only XPath function (Oracle), 7.8.1

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 31.4

IOT

See index-organized table

isSchemaBased() XMLType method, 5.4

isSchemaValid PL/SQL function, 9.3.5

isSchemaValid() XMLType method, 5.4

isSchemaValidated PL/SQL function, 9.3.3

isSchemaValidated() XMLType method, 5.4

J

Java

Oracle XML DB guidelines, 27.2

using JDBC to access XMLType objects, 27.2.2

writing Oracle XML DB applications, 27.1

JDBC

accessing XML documents, 13.2.2.1

manipulating data, 13.2.3

L

lazy XML loading (lazy manifestation), 11.1.1.1

link name

definition, 20.2.1

linking

definition, 3.18.13.1

link-properties document

definition, 3.18.13.1

large documents with collections, 7.12

loading of XML data, lazy, 11.1.1.1

LOB-based storage

definition, 2.9

LOBs

mapping XML fragments to, 7.6

local XML schema

definition, 5.5.1

using fully qualified URL to specify, 7.5

location path, B.3

M

maintainDOM attribute, 5.6.2, 5.8, 6.7.1.2

maintainOrder attribute, 5.12

mapping

collection predicates, 6.5.1.3

complexType any and anyAttributes declarations, 7.7.3

complexType to SQL, 5.12

out-of-line storage, 7.3

overriding using SQLType attribute, 5.10.2.1

predicates (XPath), 6.5.1.3

scalar nodes, 6.5.1.2

simpleContent to object types, 7.7.2

simpleType to SQL, 5.11

type information, setting, 5.10.2

matches XQuery function (Oracle), 17.5.2

maxOccurs attribute, 5.12

member functions

See methods

metadata

definition, 26.1

system-defined

definition, 1.2.5

user-defined

definition, 1.2.5

methods

XMLType

createXML(), 11.1.1.3

getBlobVal(), 4.1.3, 13.2

getClobVal(), 4.1.3

getNamespace(), 5.4

getNumberVal(), 4.1.3

getSchemaURL(), 5.4

getStringVal(), 4.1.3

isSchemaBased(), 5.4

isSchemaValid(), 5.4

isSchemaValidated(), 5.4

RootElement(), 5.4

schemaValidate(), 5.4

setSchemaValidated(), 5.4

transform(), 9.1.1

writeToStream(), 20.5.1.5

XML schema, 5.4

MIME

overriding with DBUri servlet, 19.9

modes

FORCE, 5.3.12.1

MULTISET SQL function

use with sys_XMLGen selects, 16.4.1

N

NamedNodeMap object (DOM), 11.2.10

namespace

in XPath, 6.5.1.7

URL for XML schema, 5.1

W3C, B.5

xmlns, C.1.2

XQuery, 17.4, 17.6.5

naming SQL objects, 5.8

navigational access to repository resources, 20.5

nested XML

generating using DBMS_XMLGEN, 16.3.3

generating with XMLElement, 16.2.1.3

nested XMLAgg functions and XSQL, 16.6

NESTED_TABLE_ID pseudocolumn, 3.6.7

newDOMDocument() function, 11.2.9

node_exists pseudofunction, 6.5.1.9

NodeList object (DOM), 11.2.10

NULL

XPath mapping to, 6.5.1.6

O

object identifier

definition, 24.1.1

OBJECT_ID column of XDB$ACL table, 24.1.1

object-relational storage

definition, 4.3.4.8

occurrence indicator

definition, 17.2.2

OCI API for XML, 14

OID

See object identifier

ora:contains XPath function (Oracle), 10.5

policy

definition, 10.5.4

ora:instanceof XPath function (Oracle), 7.8.2

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

ora:matches XQuery function (Oracle), 17.5.2

ora:replace XQuery function (Oracle), 17.5.3

ora:sqrt XQuery function (Oracle), 17.5.4

ora:view XQuery function (Oracle), 17.5.5

Oracle Internet Directory, 24.6

Oracle Net Services, 1.2.1

Oracle Text

contains SQL function and XMLType, 4.3

index, 1.5, 4.3.5, 10

no support for IOTs, 3.6.7

searching for resources, 22.6

searching XML in CLOBs, 1.5

Oracle XML DB

access models, 2.6

advanced queueing, 1.5

architecture, 1.2

features, 1.3

installation, 28.1

introducing, 1.1

Java applications, 27.1

Repository

See repository

upgrading, 28.2

versioning, 21

when to use, 2.2

oracle.xdb.XMLType (Java), 13.4.2.1

ordered collections in tables (OCTs)

default storage of varray, 5.12

ORGANIZATION INDEX OVERFLOW column specification, 3.6.7

out-of-line storage, 7.3

collections, 7.4

XPath rewrite, 7.3.1

P

partial update of XML data

definition, 4.2.2

path element

definition, 20.2.1

path name

definition, 20.2.1

resolution, 20.3.2

path SQL function, 22.2.3

PATH_VIEW, 22

path-based access to repository resources, 20.5

PD (positional descriptor), 5.6.2

PL/SQL APIs for XMLType, 11.1

PL/SQL DOM

examples, 11.2.12

point-to-point

support in AQ, 31

policy for ora:contains XPath function (Oracle)

definition, 10.5.4

positional descriptor (PD), 5.6.2

predicates, XPath

mapping to SQL, 6.5.1.3

collection, 6.5.1.3

pretty-printing, 4.1.1

in book examples, Preface

not done by SQL/XML functions, 3.16

privileges, access, 24.3

procedures, PL/SQL

registerSchema, 5.3.1

schemaValidate, 9.3.2

setSchemaValidated, 9.3.4

processXSL PL/SQL procedure, 11.4.3

protocol server, 25.1

architecture, 25.1.1

configuration parameters, 25.2.1

event-based logging, 25.2.5

FTP, 25.3

configuration parameters, 25.2.1

HTTP, 25.4

configuration parameters, 25.2.1

WebDAV, 25.5

configuration parameters, 25.2.1

protocols, access to repository resources, 20.5.1

pseudostructured data

See semistructured data

publish/subscribe

support in AQ, 31

purchase-order XML document, 4.1.6, 10.7.1

purchase-order XML schema, 3.5.4.1, A.2.3

annotated, 3.6.5, D.4

graphical representation, 3.5.4.2

revised, 8.3, D.4

Q

qualified XML schema URLs, 7.5

query-based access to resources

using RESOURCE_VIEW and PATH_VIEW, 22.1

using SQL, 20.6

querying XMLType data

choices, 4.1

transient data, 4.1.8

R

REF attribute, 7.3, 7.9.2

registered XML schemas, list of, 5.3.11

registering an XML schema, 5.3.1

debugging, 5.3.6

default tables, creating, 5.3.8

SQL object types, creating, 5.3.7

registerSchema PL/SQL procedure, 5.3.1

reinstalling Oracle XML DB, 28.1.4

replace XQuery function (Oracle), 17.5.3

repository, 20.2

access by anonymous user, 25.2.1

data storage, 20.3.1

hierarchical index, 3.18.14

resource

See resource

use with XQuery, 17.6.2

resource

access, 20.4

controlling, 24.3

using protocols, 25.2.3

definition, 1.2.5, 26.1

deleting, 20.3.3

non-empty container, 22.3.2.1

using DELETE, 22.3.2

managing with DBMS_XDB, 23.2

required privileges for operations, 24.3.2

searching for, using Oracle Text, 22.6

setting property in ACLs, 24.5

simultaneous operations, 22.4

updating, 22.3.3

resource content

definition, 20.2.1

resource document

definition, 3.18.7

resource id

new version, 21.2.2

resource name

definition, 20.2.1

RESOURCE_VIEW

explained, 22

retrieving large documents with collections, 7.12

rewrite

XPath, 6

XQuery, 17.7

root XML Schema

definition, 5.3.5

S

scalar nodes, mapping, 6.5.1.2

scalar value

converting to XML document using sys_XMLGen, 16.4.1

schema location hint

definition, 3.6.6

schemaValidate PL/SQL procedure, 9.3.2

schemaValidate() XMLType method, 5.4

searching CLOBs, 1.5

security

DBUri, 19.9.2

semistructured storage

definition, 2.9

servlets

accessing repository data, 20.7

APIs, 27.8

configuring, 27.4, 27.9.2

installing, 27.9.1

session pooling, 27.6, 27.6

testing, 27.9.3

writing, 27.9

in Java, 27.3

XML manipulation, 27.2.3

session pooling, 27.6

protocol server, 25.1.1

setSchemaValidated PL/SQL procedure, 9.3.4

setSchemaValidated() XMLType method, 5.4

shredded storage

definition, 1.2.1

Simple Object Access Protocol (SOAP) and IDAP, 31.4

simpleContent

mapping to object types, 7.7.2

simpleType

elements, A.2.1

mapping to SQL, 5.11

SOAP

access through Advanced Queueing, 1.2.1

IDAP, 31.4

SQL functions

updating XML data, 4.2

XMLQuery, 17.3.1

SQL object types

creating during XML schema registration, 5.3.7

SQL*Loader, 29.2

SQL*Plus

XQUERY command, 17.9

SQLCollType attribute, 5.8

SQLInline attribute, 7.3

SQLName attribute, 5.8, 5.9.1

SQLSchema attribute, 5.3.7

SQLType attribute, 5.8, 5.9.1, 7.6

SQL/XML standard, 3.16

generating XML data, 16.2

sqrt XQuery function (Oracle), 17.5.4

storage

out of line, 7.3

collections, 7.4

structured and unstructured

definitions, 5.7

uses, 1.3.3

XMLType, CREATE TABLE, 5.7.1

storeVarrayAsTable attribute, 5.8

string, XML

mapping to VARCHAR2, 5.11.1

structured storage

definition, 1.2.1, 2.9

style sheet for updating existing XML instance documents, 8.4

subtype of an XML Schema datatype

definition, 7.8

sys_DburiGen SQL function, 19.8

inserting database references, 19.8.2

retrieving object URLs, 19.8.2, 19.8.2

returning partial results, 19.8.2

use with text node test, 19.8.1

SYS_NC_ARRAY_INDEX$ column, 3.6.7

SYS_XDBPD$ attribute, 5.6.2, 6.7.1.2

XPath rewrite, 6.5

sys_XMLAgg SQL function, 16.5

sys_XMLGen SQL function, 16.4

converting a UDT to XML, 16.4.1

converting XMLType instances, 16.4.1

object views, 16.4.1

XMLFormat attributes, 16.4.1

XMLGenFormatType object, 16.4.1

system-defined metadata

definition, 1.2.5

T

tableProps attribute, 5.3.8

tablespace

do not drop, 28.1.2

temporary CLOB value, freeing, 4.1.3

textual fidelity, 2.9

transform() XMLType method, 9.1.1

type-checking, static

XQuery language, 17.8

U

UDT

generating an element from, 16.2.1.3

under_path SQL function, 22.2.1

unique constraint on parent element of an attribute, 7.2

updateXML SQL function, 4.2.3

definition, 1.3.5

mapping NULL values, 4.2.3.1

XPath rewrite, 6.7.5

updating repository resource, 22.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, 28.2

URI

base, B.6.3

URIFACTORY PL/SQL package

configuring to handle DBURI-ref, 19.9.3

creating subtypes of URIType, 19.7

Uri-reference

database and session, 19.6.3

DBUri-ref, 19.6

HTTP access for DBUri-ref, 19.9

URIFACTORY Pl/SQL package, 19.7

URIType examples, 19.4

URIType

examples, 19.4

user-defined metadata

definition, 1.2.5

V

validating

examples, 9.4

isSchemaValid PL/SQL function, 9.3.5

isSchemaValidated PL/SQL function, 9.3.3

schemaValidate PL/SQL procedure, 9.3.2

setSchemaValidated PL/SQL procedure, 9.3.4

with XML schema, 5.2.1.2

XMLIsValid PL/SQL function, 9.3.1

VCR

See version-controlled resource

version-controlled resource (VCR), 21.2, 21.2.3

access control and security, 21.3

definition, 21.1.2

versioning, 1.2.5.2, 21

view XQuery function (Oracle), 17.5.5

views

RESOURCE and PATH, 22

W

WebDAV protocol server, 25.5

WebFolder

creating in Windows 2000, 25.5.3

well-formed XML document

definition, 3.8

whitespace fidelity, 2.9

writeToStream() XMLType method, 20.5.1.5

X

XDB$ACL table, 24.1.1

XDBBinary element, 20.5.1.3

definition, 20.2.1

xdbconfig.xml configuration file, 28.4

xdbcore parameters, 7.12.1

XDBUri, 19.3.1

definition, 19.3, 19.5

XDBURIType

definition, 19.3

XML

binary datatypes, 5.11

fragments, mapping to LOBs, 7.6

primitive datatypes, 5.11

numeric, 5.11

XML schema

annotations, 3.6.3, 5.8

querying to obtain, 5.9

circular dependencies, 7.9

compared to DTD, A.14

complexType declarations, 7.7.1

creating default tables during registration, 5.3.8

cyclical dependencies, 7.9

definition, 5.1

definition (instance document), 1.3.2

deleteXML SQL function

XPath rewrite, 6.7.6

deleting, 5.3.12

elementFormDefault, 6.5.1.7

evolution, 8

features, A.14.2

for XML schemas, 5.3.5

guidelines for use with Oracle XML DB, 7.10

inheritance in, complexType restrictions, 7.7.1

local and global, 5.5

managing and storing, 5.3.5

mapping to SQL object types, 11.2.5

Oracle XML DB, 5.2

registering, 5.3.1, 5.3.1

SQL mapping, 5.9.1

updateXML SQL function

XPath rewrite, 6.7.5, 6.7.6

updating after registering, 8

URLs, 7.5

W3C Recommendation, 3.5, 5

XMLType methods, 5.4

XML Schema, overview, A.2

XML schema-based tables and columns, creating, 5.7

XML SQL Utility (XSU), generating XML, 16.7

XML string

mapping to VARCHAR2, 5.11.1

XMLAgg SQL function, 16.2.5

XMLAttributes SQL function, 16.2.1

XMLCDATA SQL function, 16.2.12

XMLColAttVal SQL function, 16.2.11

XMLComment SQL function, 16.2.7

XMLConcat SQL function, 16.2.4

XMLDATA

column, 6.5.1.2

optimizing updates, 6.7

pseudo-attribute of XMLType, 6.1, 7.9.2.1

XMLElement SQL function, 16.2.1

XMLForest SQL function, 16.2.2

XMLFormat

XMLAgg, 16.2.5

XMLFormat object type

sys_XMLGen

XMLFormatType object, 16.4.1

XMLGenFormatType object, 16.4.1

XMLIsValid PL/SQL function, 9.3.1

XMLParse SQL function, 16.2.10

XMLPI SQL function, 16.2.6

XMLQuery SQL function, 17.3, 17.3.1

XMLRoot SQL function, 16.2.8

XMLSequence SQL function, 16.2.3

XMLSerialize SQL function, 16.2.9

XMLTable SQL function, 17.3, 17.3.2

XMLtransform SQL function, 9.1.1

XMLType

benefits, 3.1.2

constructors, 3.3.1

contains SQL function, 4.3

CREATE TABLE statement, 5.7.1

DBMS_XMLDOM PL/SQL API, 11.2

DBMS_XMLPARSER PL/SQL API, 11.3

DBMS_XSLPROCESSOR PL/SQL API, 11.4

extracting data, 4.1.8

indexing columns, 4.3

instances, PL/SQL APIs, 11.1

loading data, 29.1

loading with SQL*Loader, 29.2

methods

createXML(), 11.1.1.3

getBlobVal(), 4.1.3, 13.2

getClobVal(), 4.1.3

getNamespace(), 5.4

getNumberVal(), 4.1.3

getRootElement(), 5.4

getSchemaURL(), 5.4

getStringVal(), 4.1.3

isSchemaBased(), 5.4

isSchemaValid(), 5.4

isSchemaValidated(), 5.4

schemaValidate(), 5.4

setSchemaValidated(), 5.4

transform(), 9.1.1

writeToStream(), 20.5.1.5

XML schema, 5.4

PL/SQL APIs, 11.1

querying, 4.1

querying transient data, 4.1.8

querying with extractValue and existsNode, 4.1.8

querying XMLType columns, 4.1.8

queue payloads, 31.5.1

storage architecture, 1.2.1

table, querying with JDBC, 13.2.2.1

tables, views, columns, 5.7

views, access with PL/SQL DOM APIs, 11.2.6

XPath support, 4.3

XPath

functions

ora:contains (Oracle), 10.5

ora:instanceof (Oracle), 7.8.2

ora:instanceof-only (Oracle), 7.8.1

Oracle extension functions, 7.8

overview, B.1

support for XMLType, 4.3

syntax, 4.1.2

text() node test, 6.5.1.2

XPath rewrite, 6

bind variables, 7.10.1

deleteXML SQL function, 6.7.6

existsNode SQL function, 6.7.1

extract SQL function, 6.7.3.1

extractValue SQL function, 6.7.2

indexes on singleton elements and attributes, 4.3.1

insertChildXML SQL function, 6.7.6

mapping types and paths, 6.5.1

out-of-line storage, 7.3.1

setting CURSOR_SHARING to FORCE, 7.10.1

to NULL, 6.5.1.6

updateXML SQL function, 6.7.5

using EXPLAIN PLAN to tune, 3.15.1

XQUERY command, SQL*Plus, 17.9

XQuery language, 17

expressions, 17.2.2

FLWOR, 17.2.3

rewrite, 17.7

functions

ora:contains (Oracle), 17.5.1

ora:matches (Oracle), 17.5.2

ora:replace (Oracle), 17.5.3

ora:sqrt (Oracle), 17.5.4

ora:view (Oracle), 17.5.5

item

definition, 17.2.1

namespaces, 17.4, 17.6.5

optimization, 17.7

Oracle extension functions, 17.5

Oracle XML DB support, 17.11

performance, 17.7

predefined namespaces and prefixes, 17.4

referential transparency

definition, 17.2.1

sequence

definition, 17.2.1

SQL*Plus XQUERY command, 17.9

tuning, 17.7

type-checking, static, 17.8

unordered mode

definition, 17.2.1

use with ora:view, 17.6.3

optimization, 17.7.1

use with Oracle XML DB Repository, 17.6.2

use with XMLType relational data, 17.6.4

optimization, 17.7.2

XMLQuery and XMLTable SQL functions, 17.3

examples, 17.6

xsi.noNamespaceSchemaLocation attribute, 5.1

XSLT

overview, C

style sheet for updating existing XML instance documents, 8.4

style sheets

use with DBUri servlet, 3.19.1, 3.20

use with Oracle XML DB, 3.17

use with package DBMS_XSLPROCESSOR, 11.4.3

XSQL Pages Publishing Framework

generating XML, 16.1.4, 16.6

XSU, generating XML, 16.7