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.1.4

access control list (ACL)

definition, 27.1.5

overview, 1.4.8

system, 27.4.1

account XDB, 2.1, 21.1.3, 21.1.3, 24.8, 26.1, 27.4

ACE

See access control entry

ACL

See access control list

acl-cache-size configuration parameter

root configuration, 35.4

acl-max-age configuration parameter

root configuration, 35.4

ACLOID resource property

definition, 27.4

administering Oracle XML DB, 35

Advanced Queuing (AQ)

IDAP, 38.4

messaging scenarios, 38.1.1

point-to-point support, 38

publish/subscribe support, 38

XMLType queue payloads, 38.5.1

aggregate privilege

definition, 27.1.3

ALL_JSON_COLUMNS view, 39.5.2.2

annotations

XML schema, 17.2.2, 18.2

querying to obtain, 18.2.6

anonymous user, access to repository, 28.2.1

appendChildXML SQL function (deprecated), C.11

array

JavaScript, 39.1.1

JSON, 39.1.1

array element, JSON, 39.1.1

ARRAY keyword, JSON SQL functions, 39.5.1.2

array step, Oracle JSON path expression, 39.4.1.1

ASCII escape sequences, JSON, 39.3.1

ASCII keyword, JSON SQL functions, 39.5.1.1

atomic privilege

definition, 27.1.3

attribute XML Schema data types

mapping to SQL, 18.3.2

attributes

Container, 21.3.4

xdb:columnProps, 18.2.4

xdb:defaultSchema, 18.1.2

xdb:defaultTable, 18.2.1, 18.2.4

xdb:defaultTableSchema (deprecated), Preface, 18.2.4

xdb:maintainDOM, 18.1.6, 18.2.1, 18.2.4, 18.2.4

xdb:maintainOrder (deprecated), Preface, 18.2.4

xdb:mapUnboundedStringToLob (deprecated), Preface, 18.2.4

xdb:maxOccurs (deprecated), Preface

xdb:SQLCollSchema (deprecated), Preface, 18.2.4

xdb:SQLCollType, 18.2.1, 18.2.4

xdb:SQLInline, 18.2.4, 18.8, 18.8.1, 18.8.1

xdb:SQLName, 18.2.1, 18.2.4

xdb:SQLSchema (deprecated), Preface, 18.2.4, 18.2.4

xdb:SQLType, 18.2.1, 18.2.4, 18.2.4, 18.9.3

xdb:srclang (deprecated), Preface

xdb:storeVarrayAsTable (deprecated), Preface, 18.2.4

xdb:tableProps, 18.2.4

xdb:translate (deprecated), Preface

xsi:noNamespaceSchemaLocation, 10.3.1.1, 17.1.4

authenticatedUser role

DBuri servlet security, 33.9.3

authentication

definition, 27.1.1

authorization

definition, 27.1.1

B

backward-compatible XML schema evolution

definition, 20.3.1

BASIC_STORAGE index preference, 6.4.1

binary XML

definition, 1.4.2

bootstrap ACL

definition, 27.4.1

C

C API for XML, 14

Cascading Style Sheets (CSS), 11.2.1.2

chaining XMLTable calls, 4.3.2.1

CharacterData interface, 11.2.10

check constraint used to ensure well-formed JSON, 39.5.2.1

CheckIn event, repository, 30.2

CheckOut event, repository, 30.2

child COLUMNS clause, json_table SQL function, 39.5.6

circular dependencies

XML schemas, 18.9.1

CLASSPATH environment variable

for JCR, 31.3.1

closeContext PL/SQL procedure, 12.1

collection

in out-of-line tables, 18.8.2

loading and retrieving large documents, 18.9.5

XML

definition, 17.4.1.2

collection attribute (SQL), 18.3.5

column pattern, XMLTable SQL function

definition, 4.3.2

COLUMN_VALUE pseudo-column, XMLTable SQL function, 4.3.2

columnProps attribute, 18.2.4

COLUMNS clause

json_table SQL function, 39.5.6

XMLTable SQL function, 4.3.2

complex XLink link

definition, 23.2.2

D

database role

definition, 27.1.2, 27.1.2, 27.1.2

database user

definition, 27.1.2

date and time XML Schema data types

mapping to SQL, 18.3.4

DAV: WebDAV namespace, 27.3

DBA_JSON_COLUMNS view, 39.5.2.2

DBMS_METADATA PL/SQL package, 33.3.1

reference documentation, 11.1.2, 11.1.2

DBMS_XDB PL/SQL package

reference documentation, 11.1.2

DBMS_XDB_ADMIN PL/SQL package

reference documentation, 11.1.2

DBMS_XDB_CONFIG PL/SQL package

usedPort function, 28.2.4

DBMS_XDB_REPOS PL/SQL package, 26.1

DBMS_XDB_VERSION PL/SQL package

reference documentation, 11.1.2

DBMS_XDBT PL/SQL package, 11.1.2

DBMS_XDBZ PL/SQL package, 29.7

disable_hierarchy procedure, 27.7.1

enable_hierarchy procedure, 27.7

is_hierarchy_enabled function, 29.7

purgeLDAPCache procedure, 27.6

reference documentation, 11.1.2

DBMS_XEVENT PL/SQL package

reference documentation, 11.1.2

DBMS_XMLDOM PL/SQL package, 11.2

examples, 11.2.12

reference documentation, 11.1.2

DBMS_XMLGEN PL/SQL package, 8.3

reference documentation, 11.1.2

DBMS_XMLINDEX PL/SQL package

modifyParameter procedure, 6.3.17.1

process_pending procedure, 6.3.7.3

reference documentation, 11.1.2

registerParameter procedure, 6.3.17.1

syncIndex procedure, 6.3.14

DBMS_XMLPARSER PL/SQL package, 11.3

reference documentation, 11.1.2

DBMS_XMLQUERY PL/SQL package

Oracle Java Virtual Machine dependency, B

DBMS_XMLSAVE PL/SQL package

Oracle Java Virtual Machine dependency, B

DBMS_XMLSCHEMA PL/SQL package

copyEvolve procedure, 20

deleteSchema procedure, 17.3.8

inPlaceEvolve procedure, 20

mapping types, 18.3

purgeSchema procedure, 17.3.8

reference documentation, 11.1.2

registerSchema procedure, 17.3.2, 17.3.2, 18.9.2.3

enableHierarchy parameter, 29.2

DBMS_XMLSCHEMA_ANNOTATE PL/SQL package, 18.2.3

disableDefaultTableCreation procedure, 18.2.5.1

reference documentation, 11.1.2

DBMS_XMLSTORAGE_MANAGE PL/SQL package

disableIndexesAndConstraints procedure, 36.3

enableIndexesAndConstraints procedure, 36.3

exchangePostProc procedure, 6.3.3.3

exchangePreProc procedure, 6.3.3.3

getSIDXDefFromView function, 9.4

reference documentation, 11.1.2

renameCollectionTable procedure, 19.4.2

XPath2TabColMapping procedure, 19.4, 19.4, 19.4.3

DBMS_XMLSTORE PL/SQL package, 12

reference documentation, 11.1.2

DBMS_XSLPROCESSOR PL/SQL package, 11.4

reference documentation, 11.1.2

DBUri

definition, 33.3

generating using sys_DburiGen SQL function, 33.8

identifying a row, 33.6.4.2

identifying a target column, 33.6.4.3

retrieving column text value, 33.6.4.4

retrieving the whole table, 33.6.4

security, 33.9.3

servlet, installation, 33.9.2

DBUri-refs, 33.6

HTTP access, 33.9

DBUriServlet

definition, 33.9

DBURIType

definition, 33.3

debugging

XML schema registration, 18.10

DEFAULT ON ERROR keywords, JSON SQL functions, 39.5.1.3

default tables

creating during XML schema registration, 18.1.3

defaultSchema attribute, 18.1.2

defaultTable attribute, 18.2.1, 18.2.4

defaultTableSchema attribute (deprecated), Preface, 18.2.4

Delete event, repository, 30.2

deleteSchema PL/SQL procedure, 17.3.8

deleteXML SQL function (deprecated), C.12

deleting

resource, 24.4

XML schema using DBMS_XMLSCHEMA, 17.3.8

depth SQL function, 24.2.4

derived XML Schema data types

mapping to SQL, 18.3.4

digest access authentication, 28.2.5

digest access authentication, configuring, 28.2.5

digest authentication, 28.2.5

digest authentication, configuring, 28.2.5

E

effective text value of a node

definition, 6.3.4.2

element XML Schema data types

mapping to SQL, 18.3.3

element, JSON array, 39.1.1

elements

Contents, Resource index, 21.3

XDBBinary, 21.4.1.3

EMPTY ON ERROR keywords, JSON SQL functions, 39.5.1.3

enable_hierarchy PL/SQL procedure, 27.7, 27.7

enableHierarchy parameter, DBMS_XMLSCHEMA.registerSchema, 29.2

Enterprise Manager

administering Oracle XML DB, 35.2

entities, XML

using a DTD with binary XML storage, 1.4.4

equals_path SQL function, 5.7.5.1, 24.2.2

equipartitioning of XMLType tables

definition, 18.6

error

ORA-08181, 6.3.14.1

ORA-18177, 6.4.3

error clause, JSON SQL functions, 39.5.1.3

ERROR ON ERROR keywords, JSON SQL functions, 39.5.1.3

event

repository, 30

configuring, 30.5

predefined, 30.2

event handler, repository

definition, 30.1.3

event listener, repository

definition, 30.1.3

evolution, XML schema, 20

EXISTS keyword, json_table SQL function, 39.5.6

existsNode Oracle SQL function (deprecated), Preface

extended XLink link

definition, 23.2.2

extract Oracle SQL function (deprecated), Preface

extracting data from XML, 5.2

extractValue Oracle SQL function (deprecated), Preface

F

FALSE ON ERROR keywords, JSON SQL functions, 39.5.1.3

fidelity

DOM, 17.2.3

for XML schema mapping, 11.2.5.1

SYS_XDBPD$ object attribute, 18.1.6

using SQL function updateXML, C.3.3

FLWOR XQuery expression, 4.1.4

fn:available XQuery function

support, 4.8.2.1

fn:collection XQuery function

avoiding to improve performance, 5.7.5

support, 4.8.2

fn:doc XQuery function

avoiding to improve performance, 5.7.5

support, 4.8.2

fn:id XQuery function

support, 4.8.2

fn:idref XQuery function

support, 4.8.2

fn:matches XQuery function, Preface, 4.5

fn:put XQuery function

support, 4.8.1.2

fn:replace XQuery function, Preface, 4.5

fn:tokenize XQuery function

support, 4.8.2

folder

definition, 21.2.1, 21.2.1

folder link

definition, 21.3.5.1

folder sys, repository, 21.1

foldering, 21.1

folder-restricted query

definition, 21.11

FOR ORDINALITY keywords, json_table SQL function, 39.5.6

FORMAT JSON keywords, json_table SQL function, 39.5.6

fragment, XML

definition, 3.6.6

SQL operations on, 3.6.6

fragments, XML

mapping to LOBs, 18.9.3

freeDocument PL/SQL procedure, 11.2.12

freeing a DOMdocument instance, 11.2.12

FROM list order

XMLTable PASSING clause, 5.1.4

FTP

configuration parameters, 28.2.1

creating default tables, 18.1.3

protocol server, features, 28.3

full-text indexing, 6.4

full-text search

JSON data, 39.8

XML data, 4.1.2.5, 4.8.3

fully qualified XML schema URLs, 17.3.7

functional evaluation

definition, 19.4.1

functions

PL/SQL

createResource, 3.5.6

getSIDXDefFromView, 9.4

is_hierarchy_enabled, 29.7

usedPort, 28.2.4

SQL

appendChildXML (deprecated), C.11

deleteXML (deprecated), C.12

depth, 24.2.4

equals_path, 5.7.5.1, 24.2.2

existsNode (deprecated), Preface

extract (deprecated), Preface

extractValue (deprecated), Preface

insertChildXML (deprecated), C.6

insertChildXMLafter (deprecated), C.8

insertChildXMLbefore (deprecated), C.7

insertXMLafter (deprecated), C.10

insertXMLbefore (deprecated), C.9

json_query, 39.5.5

json_table, 39.5.6

json_value, 39.5.4

path, 24.2.3

sys_DburiGen, 33.8

sys_XMLAgg, 8.4

under_path, 24.2.1, 24.3

updateXML (deprecated), C.3

updating XML data, 5.6

XMLAgg, 8.2.4

XMLAttributes, 8.2.1

XMLCast, 4.3.4

XMLCDATA, 8.2.11

XMLColAttVal, 8.2.10

XMLComment, 8.2.6

XMLConcat, 8.2.3

XMLElement, 8.2.1

XMLExists, 4.3.3

XMLForest, 8.2.2

XMLIsValid, 7.2, 7.2.1.2.1

XMLParse, 8.2.8

XMLPI, 8.2.5

XMLQuery, 4.3, 4.3.1

XMLRoot, 8.2.9

XMLSequence (deprecated), Preface

XMLSerialize, 8.2.7

XMLTable, 4.3, 4.3.2

XMLtransform, 7.1.1

XPath

ora:instanceof (deprecated), Preface

ora:instanceof-only (deprecated), Preface, Preface

G

generating XML, 8

DBMS_XMLGEN PL/SQL package, 8.3

SQL functions, 8.1

sys_XMLAgg SQL function, 8.4

XMLAgg SQL function, 8.2.4

XMLAttributes SQL function, 8.2.1

XMLCDATA SQL function, 8.2.11

XMLColAttVal SQL function, 8.2.10

XMLComment SQL function, 8.2.6

XMLConcat SQL function, 8.2.3

XMLElement SQL function, 8.2.1

XMLForest SQL function, 8.2.2

XMLParse SQL function, 8.2.8

XMLPI SQL function, 8.2.5

XMLRoot SQL function, 8.2.9

XMLSerialize SQL function, 8.2.7

getBLOBVal() Oracle XMLType method (deprecated), Preface

getCLOB() XMLType method, 13.3

getCLOBVal() Oracle XMLType method (deprecated), Preface

getNamespace() Oracle XMLType method (deprecated), Preface

getNumberVal() XMLType method, 4.1.1

getObject() XMLType method, 13.2.1.2

getOPAQUE() XMLType method, 13.2.1.2

getRootElement() Oracle XMLType method (deprecated), Preface

getSchemaURL() XMLType method, 17.2.4

getSIDXDefFromView PL/SQL function, 9.4

getStringVal() Oracle XMLType method (deprecated), Preface

getting JCR repository objects, 31.3.2

global XML schema

definition, 17.3.6.2

using fully qualified URL to override, 17.3.7

group in an XMLIndex structured component

definition, 6.3.7

H

hard link

definition, 21.3.5.2

JCR, 31.2.6

hierarchical repository index, 21.12

hierarchy-enabled table

definition, 27.7

HTTP

access for DBUri-refs, 33.9

accessing Java servlet or XMLType, 32.2.1

accessing repository resources, 21.4.1.2

configuration parameters, WebDAV, 28.2.1

creating default tables, 18.1.3

improved performance, 28.1.1

Oracle XML DB servlets, 32.5

protocol server, features, 28.4

requests, 32.5

servlets, 32.3

URIFACTORY, 33.9.4

using UriRefs to store pointers, 33.3

httpconfig element, xdbconfig.xml, 35.3.1.5

HTTPUri

definition, 33.3

HTTPURIType

definition, 33.3

hybrid columnar compression, B

I

IDAP

architecture, 38.5

transmitted over Internet, 38.4

index

hierarchical repository, 21.12

indexing, 39.7.3, 39.7.5

CTXCAT, E.4.5.1

CTXRULE, E.4.5.1

full-text, 6.4

Oracle Text, E

XML-enabled, 6.4

XMLType, 6.2

choosing, 16

indexing JSON data, 39.7

composite B-tree index for multiple properties, 39.7.6

for json_table queries, 39.7.4

for search, 39.8

is json SQL condition indexing JSON data

is not json SQL condition, 39.7

json_exists SQL condition, 39.7.2

json_value SQL function, 39.7.3

data type considerations, 39.7.5

for json_table queries, 39.7.4

index-organized tables, 18.1.1

inheritance

XML schema, restrictions in complexTypes, 18.4.1

in-place XML schema evolution, 20.3

inPlaceEvolve PL/SQL procedure, 20

insertChildXML SQL function (deprecated), C.6

insertChildXMLafter SQL function (deprecated), C.8

insertChildXMLbefore SQL function (deprecated), C.7

insertXML() XMLType method, 13.3

insertXMLafter SQL function (deprecated), C.10

insertXMLbefore SQL function (deprecated), C.9

instance document

definition, 1.4.3, 17.1.3

specifying root element namespace, 17.1.4

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 38.4

Internet Protocol Version 6

FTP, 28.3.1.7

HTTP(S), 28.4.1.3

IPv6

FTP, 28.3.1.7

HTTP(S), 28.4.1.3

is json SQL condition, 39.5.2

indexing is not json SQL condition

indexing, 39.7

STRICT keyword, 39.5.2.5

is not json SQL condition, 39.5.2

STRICT keyword, 39.5.2.5

is_hierarchy_enabled PL/SQL function, 29.7

isSchemaBased() XMLType method, 17.2.4

isSchemaValid() XMLType method, 17.2.4

IsSchemaValid() XMLType method, 7.2

isSchemaValidated() XMLType method, 7.2, 17.2.4

J

Java

connections, thick and thin, 13.4

DOM API for XMLType, 13.1

Oracle XML DB applications, 32.1

oracle.xml.parser.v2, 13.1

Java Content Repository API

See JCR

Java Specification Request

170, Preface, 31

173, Preface

225, 5.4

JavaScript

array, 39.1.1

object, 39.1.1

object literal, 39.1.1

JavaScript notation compared with JSON, 39.1

JavaScript Object Notation (JSON), 39.1

JCR, 31

compliance levels supported, 31.3.6

document view serialization

definition, 31.2.3

files and folders, exposure, 31.2.1

getPath() Java method, 31.2.6

hard link, 31.2.6

logging, 31.3.5

Oracle XML DB Repository access, 31.2

overview, 31.1.1

restrictions for Oracle XML DB Content Connector, 31.3.7

weak link, 31.2.6

XML schema, 31.4

JCR node types

mapping from XML Schema data types, 31.4.3

mapping from XML Schema global element declarations, 31.4.3.4

nt:file, 31.2

nt:folder, 31.2

Oracle extensions, 31.2.2

jcr:content, 31.2.5

jcr:data property, 31.2.3

JDBC

accessing XML documents, 13.2.1.2

drivers, OCI and thin, 13.2.2

loading large XML documents, 13.3

manipulating XML documents, 13.2.2

JSON, 39.1

array, 39.1.1

array element, 39.1.1

ASCII escape sequences, 39.3.1

character encoding, 39.3

character-set conversion, 39.3

compared with JavaScript notation, 39.1

compared with XML, 39.1.2

object, 39.1.1

object member, 39.1.1

path expression, 39.4

syntax, 39.4.1

scalar value, 39.1.1

syntax

lax, 39.5.2.4

strict, 39.5.2.4

value, 39.1.1

JSON search index, 39.8

definition, 39.7

JSON SQL function

WITH WRAPPER keywords, 39.5.1.2

WITHOUT WRAPPER keywords, 39.5.1.2

JSON SQL functions

DEFAULT ON ERROR keywords, 39.5.1.3

EMPTY ON ERROR keywords, 39.5.1.3

ERROR ON ERROR keywords, 39.5.1.3

FALSE ON ERROR keywords, 39.5.1.3

json_query, 39.5.5

as json_table, 39.5.5.1

json_table, 39.5.6

json_value, 39.5.4

as json_table, 39.5.4.3

NULL ON ERROR keywords, 39.5.1.3

TRUE ON ERROR keywords, 39.5.1.3

WITH ARRAY WRAPPER keywords, 39.5.1.2

WITH CONDITIONAL WRAPPER keywords, 39.5.1.2

WITH UNCONDITIONAL WRAPPER keywords, 39.5.1.2

json_exists SQL condition, 39.5.3

as json_table, 39.5.3.1

indexing, 39.7, 39.7.2

json_query SQL function, 39.5.5

as json_table, 39.5.5.1

ASCII keyword, 39.5.1.1

PRETTY keyword, 39.5.1.1, 39.5.1.1

json_table

indexing for queries, 39.7.4

json_table SQL function, 39.5.6

EXISTS keyword, 39.5.6

FOR ORDINALITY keywords, 39.5.6

FORMAT JSON keywords, 39.5.6

PATH clause, 39.5.6

json_textcontains SQL condition, 39.8

json_value SQL function, 39.5.4, 39.7.3, 39.7.5

as json_table, 39.5.4.3

ASCII keyword, 39.5.1.1

indexing for json_table queries, 39.7.4

JSR-170, Preface, 31

L

large node handling, 11.2.13

lax JSON syntax, 39.5.2.4

lazy XML loading (lazy manifestation), 11.1.1.1

LDAP principal

definition, 27.1.2

link

document

definition, 21.3.5.1

folder

definition, 21.3.5.1

hard

definition, 21.3.5.2

repository

definition, 21.3.5.1

weak

definition, 21.3.5.2

link name

definition, 21.2.1

LinkIn event, repository, 30.2

linking, repository

definition, 21.5

link-properties document

definition, 21.5

LinkTo event, repository, 30.2

large documents with collections, 18.9.5

loading large XML documents using JDBC, 13.3

loading of XML data, lazy, 11.1.1.1

LOB locator, 25.5

LOBs

mapping XML fragments to, 18.9.3

local XML schema

definition, 17.3.6.1

using fully qualified URL to specify, 17.3.7

Lock event, repository, 30.2

M

maintainDOM attribute, 18.1.6, 18.2.1, 18.2.4, 18.2.4

maintainOrder attribute (deprecated), Preface, 18.2.4

manifestation, lazy, 11.1.1.1

mapping

complexType to SQL

out-of-line storage, 18.8.1

overriding using SQLType attribute, 18.3.3.1

simpleContent to object types, 18.4.2

mapping XML Schema complexType data types to SQL, 18.3.5

mapping XML Schema data types to SQL data types, 18.3

mapUnboundedStringToLob attribute (deprecated), Preface, 18.2.4

matches XQuery function, Preface, 4.5

maxOccurs attribute in xdb namespace (deprecated), Preface

metadata

definition, 29.1

system-defined

definition, 1.4.8

user-defined

definition, 1.4.8

methods

XMLType

createXML(), 11.1.1.3, 13.2.1

getBLOBVal() (deprecated), Preface

getCLOB(), 13.3

getCLOBVal() (deprecated), Preface

getNamespace() (deprecated), Preface

getNumberVal(), 4.1.1

getObject(), 13.2.1.2

getOPAQUE(), 13.2.1.2

getRootElement() (deprecated), Preface

getSchemaURL(), 17.2.4

getStringVal() (deprecated), Preface

insertXML(), 13.3

isSchemaBased(), 17.2.4

isSchemaValid(), 17.2.4

IsSchemaValid(), 7.2

isSchemaValidated(), 7.2, 17.2.4

schemaValidate(), 17.2.4

setObject(), 13.2.2

setSchemaValidated(), 7.2, 17.2.4

writeToStream(), 21.4.1.5

XML schema, 17.2.4

MIME

overriding with DBUri servlet, 33.9.1

mix:referenceable, 31.2.3

model, XML Schema

definition, 20.3.1.1.4

modifyParameter PL/SQL procedure, 6.3.17.1

N

NamedNodeMap object (DOM), 11.2.10

namespace

prefixes

ocjr, 31.2.2

XQuery, 4.2.2, 5.1.5

naming SQL objects, 18.2

navigational access to repository resources, 21.4

NESTED PATH clause, json_table, json_table SQL function

NESTED PATH clause, 39.5.6.2

nested XML

generating using DBMS_XMLGEN, 8.3.3

generating with XMLElement, 8.2.1.3

NESTED_TABLE_ID pseudocolumn, 18.5

newDOMDocument() function, 11.2.9

NodeList object (DOM), 11.2.10

nodes, large (DBMS_XMLDOM), 11.2.13

noNamespaceSchemaLocation attribute, 10.3.1.1, 17.1.4

nonce

definition, 28.2.5.1

nonce key

definition, 28.2.5.1

non-schema-based view

definition, 10.1

nt:file JCR node type, 31.2

nt:folder, 31.2

nt:folder JCR node type, 31.2

NULL ON ERROR keywords, JSON SQL functions, 39.5.1.3

numeric XML Schema data types

mapping to SQL, 18.3.4

O

object attributes

for collection (SQL), 18.3.5

REF, 18.8.1, 18.9.1.2

sys_DburiGen SQL function

passing to, 33.8.1

SYS_XDBPD$, 18.1.6

XMLType, in AQ, 38.5.1

object identifier

definition, 27.4

object literal, JavaScript, 39.1.1

object member, JSON, 39.1.1

object step, Oracle JSON path expression, 39.4.1.1

object, JavaScript, 39.1.1

object, JSON, 39.1.1

OBJECT_ID column of XDB$ACL table, 27.4

object-based persistence of XML data

definition, 1.4.2

object-relational storage of XML data

definition, 1.4.2

occurrence indicator

definition, 4.1.3

OCI API for XML, 14

ocjr namespace prefix, 31.2.2

OCT

definition, 18.1.1

ODP.NET, 15

OID

See object identifier

ojcr:folder, 31.2.3

optimizer hints

COST_XML_QUERY_REWRITE, 5.7.1

ora:child-element-name Oracle XQuery pragma, 4.6

ora:contains Oracle XPath function, E.5

policy

definition, E.5.4

ora:defaultTable Oracle XQuery pragma, 4.6, 5.7.5.2

ora:instanceof Oracle XPath function (deprecated), Preface

ora:instanceof-only Oracle XPath function (deprecated), Preface, Preface

ora:invalid_path Oracle XQuery pragma, 4.6

ora:matches Oracle XQuery function (deprecated), Preface, 4.5.4

ora:no_schema Oracle XQuery pragma, 4.6, 6.4.3, 16.3.2

ora:no_xmlquery_rewrite Oracle XQuery pragma, 4.6, 6.3.9

ora:replace Oracle XQuery function (deprecated), Preface, 4.5.5

ora:sqrt Oracle XQuery function, 4.5.2

ora:tokenize Oracle XQuery function, 4.5.3

ora:transform_keep_schema Oracle XQuery pragma, 4.6

ora:use_xmltext_idx Oracle XQuery pragma, 4.6, 6.4.4

ora:view_on_null Oracle XQuery pragma, 4.6

ora:xmlquery_rewrite Oracle XQuery pragma, 4.6

ora:xq_proc Oracle XQuery pragma (deprecated), 4.6

ora:xq_qry Oracle XQuery pragma (deprecated), 4.6

ORA-08181 error, 6.3.14.1

ORA-18177 error, 6.4.3

Oracle ASM files

accessing, 21.4.2

using FTP, 28.3.1.5

Oracle ASM virtual folder, 21.3.1.3

Oracle Data Provider for .NET, 15

Oracle Enterprise Manager

administering Oracle XML DB, 35.2

Oracle extensions to JCR node types, 31.2.2

Oracle Internet Directory, 27.8

Oracle JSON path expression, 39.4

Oracle Net Services, 1.3

Oracle Text

index, E

searching for resources, 24.8

XML-enabled index, 6.4

Oracle XML DB

access models, 2.3.5

architecture, 1.3

features, 1.4

Java applications, 32.1

overview, 1.1

Repository

See repository

upgrading, 35.1

versioning, 25

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

parent COLUMNS clause, json_table SQL function, 39.5.6

partial update of XML data

definition, C.2

partial validation of XML data

definition, 7.2.1.1

partitioning XMLType tables, 18.6

PASSING clause of XMLTable

FROM list order, 5.1.4

PATH clause, json_table, 39.5.6

path component of a resource path name

definition, 21.2.1

path expression, JSON, 39.4, 39.4.1

path index of XMLIndex

definition, 6.3.4

path name

definition, 21.2.1

resolution, 21.3.4

path SQL function, 24.2.3

path table of XMLIndex, 6.3.4

PATH_VIEW, 24

path-based access to repository resources, 21.4

path-index trigger

definition, 27.7

PD (positional descriptor), 18.1.6

persistence models for XML data, 1.4.2

plsql element, xdbconfig.xml

child of httpconfig, 35.3.1.5

child of servlet, 35.3.1.6

PL/SQL functions

See functions, PL/SQL

PL/SQL packages

DBMS_METADATA, 33.3.1

reference documentation, 11.1.2, 11.1.2

DBMS_XDB

reference documentation, 11.1.2

DBMS_XDB_ADMIN

reference documentation, 11.1.2

DBMS_XDB_REPOS, 26.1

DBMS_XDB_VERSION

reference documentation, 11.1.2

DBMS_XDBT, 11.1.2

DBMS_XDBZ, 27.7, 29.7

reference documentation, 11.1.2

DBMS_XEVENT

reference documentation, 11.1.2

DBMS_XMLDOM, 11.2

reference documentation, 11.1.2

DBMS_XMLGEN, 8.3

reference documentation, 11.1.2

DBMS_XMLINDEX

reference documentation, 11.1.2

DBMS_XMLPARSER, 11.3

reference documentation, 11.1.2

DBMS_XMLQUERY

Oracle Java Virtual Machine dependency, B

DBMS_XMLSAVE

Oracle Java Virtual Machine dependency, B

DBMS_XMLSCHEMA

reference documentation, 11.1.2

DBMS_XMLSCHEMA_ANNOTATE, 18.2.3

reference documentation, 11.1.2

DBMS_XMLSTORAGE_MANAGE

reference documentation, 11.1.2

DBMS_XMLSTORE, 12

reference documentation, 11.1.2

DBMS_XSLPROCESSOR, 11.4

reference documentation, 11.1.2

for XMLType, 11.1

PL/SQL procedures

See procedures, PL/SQL

point-to-point

support in AQ, 38

policy for ora:contains XPath function (Oracle)

definition, E.5.4

port, FTP, 28.2.1

port, HTTP, 28.2.1

ports

configuring

FTP, 28.2.1

HTTP, 28.2.1

HTTPS, 28.2.2

positional descriptor (PD), 18.1.6

post-parse persistence of XML data

definition, 1.4.2

pragmas, XQuery

See XQuery pragmas, Oracle

predefined ACLs, 27.4.1

preference

Oracle Text indexing

definition, E.4.5.1

PRETTY keyword, JSON SQL functions, 39.5.1.1

PRETTY keyword, json_query, 39.5.1.1

pretty-printing, 8.2.7

in book examples, Preface

not done by SQL/XML functions, 3.8.1

Web service output, 34.3

primitive XML Schema data types

mapping to SQL, 18.3.4

principal

definition, 27.1.2, 27.1.2

LDAP

definition, 27.1.2

private (local) XML schema, definition, 17.3.6

privilege

definition, 27.1.3

procedures

PL/SQL

closeContext, 12.1

copyEvolve, 20

disable_hierarchy, 27.7.1

disableDefaultTableCreation, 18.2.5.1

disableIndexesAndConstraints, 36.3

enable_hierarchy, 27.7, 27.7

enableIndexesAndConstraints, 36.3

exchangePostProc, 6.3.3.3

exchangePreProc, 6.3.3.3

freeDocument, 11.2.12

inPlaceEvolve, 20

modifyParameter, 6.3.17.1

process_pending, 6.3.7.3

processXSL, 11.4.3

purgeLDAPCache, 27.6

registerParameter, 6.3.17.1

registerSchema, 17.3.2, 17.3.2

renameCollectionTable, 19.4.2

setKeyColumn, 12.1

setUpdateColumn, 12.1

syncIndex, 6.3.14

XPath2TabColMapping, 19.4, 19.4, 19.4.3

process_pending PL/SQL procedure, 6.3.7.3

processXSL PL/SQL procedure, 11.4.3

protocol server, 28.1

architecture, 28.1.1

configuration parameters, 28.2.1

event-based logging, 28.2.8

FTP, 28.3

configuration parameters, 28.2.1

HTTP, 28.4

configuration parameters, 28.2.1

WebDAV

configuration parameters, 28.2.1

protocolconfig element, xdbconfig.xml, 35.3.1.4

protocols, access to repository resources, 21.4.1

public (global) XML schema, definition, 17.3.6

publish/subscribe

support in AQ, 38

purchase-order XML document

used in full-text examples, E.7.1

purchase-order XML schema, A.6

annotated, A.6

revised, 20.2.1, A.6

purgeLDAPCache PL/SQL procedure, 27.6

purgeSchema PL/SQL procedure, 17.3.8

Q

qualified XML schema URLs, 17.3.7

query-based access to resources

using RESOURCE_VIEW and PATH_VIEW, 24.1

using SQL, 21.5

querying XMLType data

choices, 5.2

transient data, 5.2

R

ra:use_text_index Oracle XQuery pragma, E.5.5.2

recursive schema support, 18.9.2

REF object attribute, 18.8.1, 18.9.1.2

REGISTER_NT_AS_IOT option for XML schema registration, 17.3.2, 18.1.1, 18.1.1

registered XML schemas, list of, 17.3.9

registering an XML schema

debugging, 18.10

default tables, creating, 18.1.3

SQL object types, creating, 18.1.2

registering an XML schema for JCR, 31.4.1

registerParameter PL/SQL procedure, 6.3.17.1

registerSchema PL/SQL procedure, 17.3.2, 17.3.2

renaming an XMLIndex index, 6.3.5

Render event, repository, 30.2

replace XQuery function, Preface, 4.5

repository, 21.2

access by anonymous user, 28.2.1

access using JCR, 31.2

data storage, 21.3.1

event, 30

configuring, 30.5

predefined, 30.2

event handler

definition, 30.1.3

event listener

definition, 30.1.3

hierarchical index, 21.12

use with XQuery, 5.1.2

repository link

definition, 21.3.5.1

repository objects, 31.3.2

RESID

definition, 25.3

resource

access, 21.1.2

using protocols, 28.2.6

definition, 1.4.8, 29.1

deleting, 21.3.5.2

nonempty container, 24.4.1

using DELETE, 24.4

management using DBMS_XDB_REPOS, 26.1

managing with DBMS_XDB, 35.5

required privileges for operations, 27.2

searching for, using Oracle Text, 24.8

setting property in ACLs, 27.5

simultaneous operations, 24.6

updating, 24.5

resource configuration file

definition, 22.1

resource configuration list

definition, 22.1

resource content

definition, 21.2.1

resource document

definition, 21.1.3

resource ID

definition, 25.3

resource name

definition, 21.2.1

resource version

definition, 25.1

RESOURCE_VIEW

explained, 24

resource-view-cache-size configuration parameter, 24.7

root configuration, 35.4

retrieving large documents with collections, 18.9.5

RETURNING clause, JSON SQL functions, 39.5.1.1

RETURNING SEQUENCE BY REF clause of XMLTable, 5.1.4

revalidation mode, XQuery Update, 4.8.1.1

rewrite

XPath (XPath), 19

XQuery, 5.7

role

authenticatedUser, DBuri servlet, 33.9.3

CTXAPP, 6.4.1

database

definition, 27.1.2

XDB_SET_INVOKER, 30.5.1

XDBADMIN, 17.3.6.2, 22.1, 27.4.1, 30.5

root configuration, 35.4

root folder, repository, 21.1

root XML Schema

definition, 17.2

row pattern, XMLTable SQL function

definition, 4.3.2

row source

JSON

definition, 39.5.6

rule-based XML query rewrite

definition, 5.7.1

S

scalar JSON value, 39.1.1

schema evolution

See XML schema evolution

schema for schemas (XML Schema)

definition, 1.4.3

schema location hint

definition, 17.3

schemaValidate() XMLType method, 17.2.4

security

DBUri, 33.9.3

servlet element, xdbconfig.xml, 35.3.1.6

servletconfig element, xdbconfig.xml, 35.3.1.5

servletlist element, xdbconfig.xml, 35.3.1.5

servlets

accessing repository data, 21.6

APIs, 32.8

configuring, 32.4

session pooling, 32.6, 32.6

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, 12.1

setObject() XMLType method, 13.2.2

setSchemaValidated() XMLType method, 7.2, 17.2.4

setUpdateColumn PL/SQL procedure, 12.1

sibling COLUMNS clauses, json_table SQL function, 39.5.6

simple XLink link

definition, 23.2.2

simpleContent

mapping to object types, 18.4.2

SOAP, 34.1

IDAP, 38.4

SQL conditions

IS (NOT) NULL and JSON null, 39.1.1

is json, 39.5.2

indexing, 39.7

is not json, 39.5.2

indexing, 39.7

json_exists, 39.5.3

as json_table, 39.5.3.1

indexing, 39.7, 39.7.2

json_textcontains, 39.8

SQL functions

See functions, SQL

SQL object types

creating during XML schema registration, 18.1.2

SQL*Loader, 36.2

SQL*Plus

XQUERY command, 5.3

SQLCollSchema attribute (deprecated), Preface, 18.2.4

SQLCollType attribute, 18.2.1, 18.2.4

SQLInline attribute, 18.2.4, 18.8, 18.8.1, 18.8.1

SQLJ, 13.4.2.1

SQLName attribute, 18.2.1, 18.2.4

SQLSchema attribute (deprecated), Preface, 18.2.4, 18.2.4

SQLType attribute, 18.2.1, 18.2.4, 18.2.4, 18.9.3

SQL/XML generation functions

definition, 1.4.6, 8.2

SQL/XML publishing functions

definition, 1.4.6, 8.2

SQL/XML query and update functions

definition, 1.4.6

SQL/XML standard

generating XML data, 8.2

querying XML data

XMLQuery and XMLTable, 4.3

sqrt XQuery function (Oracle), 4.5.2

srclang attribute (deprecated), Preface

standard metadata, 31.2.4

static type-checking

XQuery language, 4.7

step, Oracle JSON path expression, 39.4.1.1

storage

out of line, 18.8.1

collections, 18.8.2

storage models for XMLType, 1.4.2

choosing, 16

storeVarrayAsTable attribute (deprecated), Preface, 18.2.4

strict JSON syntax, 39.5.2.4

STRICT keyword for is (not) json syntax, 39.5.2.5

string XML Schema data types

mapping to SQL, 18.3.4

mapping to VARCHAR2 vs CLOB, 18.3.4.2

structured storage of XMLType data

definition, 1.4.2, 16.1

structured XMLIndex component

definition, 6.3.2

style sheet, CSS, 11.2.1.2

stylesheet for updating XML instance documents, 20.2.5

syncIndex PL/SQL procedure, 6.3.14

sys folder, repository, 21.1

sys_DburiGen SQL function, 33.8

inserting database references, 33.8.2

retrieving object URLs, 33.8.2.2, 33.8.2.2

use with text node test, 33.8.1

SYS_NC_ARRAY_INDEX$ column, 18.5

SYS_XDBPD$ object attribute, 18.1.6

sys_XMLAgg SQL function, 8.4

sysconfig element, xdbconfig.xml, 35.3.1.2

system ACL

definition, 27.4.1

system ACLs, 27.4.1

system-defined metadata

definition, 1.4.8

T

tableProps attribute, 18.2.4

tables

index-organized, 18.1.1

text value of a node, effective

definition, 6.3.4.2

third-party XLink link

definition, 23.2.2

time zone support, implicit, 4.8.1.1

translate attribute (deprecated), Preface

trigger, path-index

definition, 27.7

TRUE ON ERROR keywords, JSON SQL functions, 39.5.1.3

type-checking, static and dynamic

XQuery language, 4.7

U

UDT

generating an element from, 8.2.1.3

UncheckOut event, repository, 30.2

UNCONDITIONAL keyword, JSON SQL functions, 39.5.1.2, 39.5.1.2

under_path SQL function, 24.2.1

different correlations for different folders, 24.3

uniform access control mechanism

definition, 27.7

unique constraint on parent element of an attribute, 18.7.1

unique keys in JSON objects, 39.5.2.3

UnLinkIn event, repository, 30.2

Unlock event, repository, 30.2

unresolved XLink and XInclude links, 23.7.1

unstructured XMLIndex component

definition, 6.3.2

Update event, repository, 30.2

updateXML SQL function

mapping NULL values, 5.6.2.1, C.3.1

updateXML SQL function (deprecated), C.3

updating repository resource, 24.5

updating XML data

partial update

definition, C.2

updating same node more than once, C.3.2

using SQL functions, 5.6

optimization, C.4

upgrading Oracle XML DB, 35.1

URIFACTORY PL/SQL package

configuring to handle DBURI-ref, 33.9.4

creating subtypes of URIType, 33.7

Uri-reference

database and session, 33.6.3

DBUri-ref, 33.6

HTTP access for DBUri-ref, 33.9

URIFACTORY PL/SQL package, 33.7

URIType examples, 33.4

URIType

examples, 33.4

usedPort PL/SQL function, 28.2.4

user

definition, 27.1.2

user XDB, 2.1, 21.1.3, 21.1.3, 24.8, 26.1, 27.4

USER_JSON_COLUMNS view, 39.5.2.2

userconfig element, xdbconfig.xml, 35.3.1.3

user-defined metadata, 31.2.5

definition, 1.4.8

V

validating

examples, 7.2.2

IsSchemaValid() XMLType method, 7.2

isSchemaValidated() XMLType method, 7.2

setSchemaValidated() XMLType method, 7.2

XMLIsValid SQL function, 7.2

use as CHECK constraint, 7.2.1.2.1

validation of XML data, partial

definition, 7.2.1.1

value index of XMLIndex

definition, 6.3.4

varray in a LOB

definition, 18.1.1

varray in a table

definition, 18.1.1

VCR

See version-controlled resource

version resource

definition, 25.1

version series of a resource

definition, 25.3

versionable resource

definition, 25.1

VersionControl event, repository, 30.2

version-controlled resource

definition, 25.1

versioning, 1.4.8, 25

view

ALL_JSON_COLUMNS, 39.5.2.2

DBA_JSON_COLUMNS, 39.5.2.2

USER_JSON_COLUMNS, 39.5.2.2

views

RESOURCE and PATH, 24

W

weak link

definition, 21.3.5.2

deletion, 23.7.1

JCR, 31.2.6

Web service, 34.1

pretty-printing output, 34.3

webappconfig element, xdbconfig.xml, 35.3.1.5

WebDAV

definition, 21.1

WebDAV namespace DAV:, 27.3

WebFolder

creating in Windows 2000, 28.5.3

well formed JSON data, 39.5.2

well-formed XML document

definition, 3.4

WITH ARRAY WRAPPER keywords,JSON SQL functions, 39.5.1.2

WITH CONDITIONAL WRAPPER keywords, JSON SQL functions, 39.5.1.2

WITH UNCONDITIONAL WRAPPER keywords, JSON SQL functions, 39.5.1.2

WITH UNIQUE KEYS keywords, JSON condidtion is json, 39.5.2.3

WITH WRAPPER keywords, JSON SQL functions, 39.5.1.2

WITHOUT UNIQUE KEYS keywords, JSON condidtion is json, 39.5.2.3

WITHOUT WRAPPER keywords,JSON SQL functions, 39.5.1.2

wrapper clause, JSON SQL functions, 39.5.1.2

WRAPPER keyword, JSON SQL functions, 39.5.1.2

writeToStream() XMLType method, 21.4.1.5

WSDL

Web service for accessing stored PL/SQL, 34.4

Web service for database queries, 34.3

X

XDB database schema (user account), 2.1, 21.1.3, 21.1.3, 21.1.3, 24.8, 26.1, 27.4

xdb namespace, 27.3

XDB$ACL table, 27.4

xdb:columnProps attribute, 18.2.4

xdb:defaultSchema attribute, 18.1.2

xdb:defaultTable attribute, 18.2.1, 18.2.4

xdb:defaultTableSchema attribute (deprecated), Preface, 18.2.4

xdb:maintainDOM attribute, 18.1.6, 18.2.1, 18.2.4, 18.2.4

xdb:maintainOrder attribute (deprecated), Preface, 18.2.4

xdb:mapUnboundedStringToLob attribute (deprecated), Preface, 18.2.4

xdb:maxOccurs attribute (deprecated), Preface

xdb:SQLCollSchema attribute (deprecated), Preface, 18.2.4

xdb:SQLCollType attribute, 18.2.1, 18.2.4

xdb:SQLInline attribute, 18.2.4, 18.8, 18.8.1, 18.8.1

xdb:SQLName attribute, 18.2.1, 18.2.4

xdb:SQLSchema attribute (deprecated), Preface, 18.2.4, 18.2.4

xdb:SQLType attribute, 18.2.1, 18.2.4, 18.2.4, 18.9.3

xdb:srclang attribute (deprecated), Preface

xdb:storeVarrayAsTable attribute (deprecated), Preface, 18.2.4

xdb:tableProps attribute, 18.2.4

xdb:translate attribute (deprecated), Preface

XDB_SET_INVOKER role, 30.5.1

XDBADMIN role, 17.3.6.2, 22.1, 27.4.1, 27.4.1, 30.5

XDBBinary element, 21.4.1.3

definition, 21.2.1

xdbconfig element, xdbconfig.xml, 35.3.1.1

xdbconfig.xml configuration file, 35.3

xdbcore parameters, 18.9.5.1

xdbcore-loadableunit-size configuration parameter, 18.9.5, 24.7

root configuration, 35.4

xdbcore-xobmem-bound configuration parameter, 18.9.5, 24.7

root configuration, 35.4

XDBSchema.xsd

definition, 17.2

XDBUri, 33.3.1

definition, 33.3, 33.5

XDBURIType

definition, 33.3

using constructor to expand compound documents (XInclude), 23.5.1, 23.5.1

XInclude, 23

definition, 23.1

unresolved link, 23.7.1

XLink

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

compared with JSON, 39.1.2

XML attributes

See attributes

XML diagnosability mode, 5.7.4

XML entities

using a DTD with binary XML storage, 1.4.4

XML fragment

definition, 3.6.6

mapping to LOBs, 18.9.3

SQL operations on, 3.6.6

XML instance document

definition, 1.4.3, 17.1.3

XML query rewrite

definition, 5.7

cost-based, 5.7.1

rule-based, 5.7.1

XML schema

annotations, 17.2.2, 18.2

querying to obtain, 18.2.6

circular dependencies, 18.9.1

complexType declarations, 18.4.1, 18.9.1.2

cyclical dependencies, 18.9.1

definition, 1.4.3, 17.1

deletion, 17.3.8

evolution, 20

backward-compatible, definition, 20.3.1

for XML schemas that can be registered, 17.2

inheritance in, complexType restrictions, 18.4.1

local and global, 17.3.6

mapping to SQL object types, 11.2.5

registration with Oracle XML DB

for use with JCR, 31.4.1

updating after registering, 20

URLs, 17.3.7

use with JCR, 31.4

W3C Recommendation, 17, 17.1

XMLType methods, 17.2.4

XML Schema

definition, Preface

XML Schema data types

mapping to JCR node types, 31.4.3

mapping to SQL data types, 18.3

XML schema definition

definition, 1.4.3

XML schema evolution

copy-based, 20.2

in-place, 20.3

XML schema-based tables and columns, creating, 17.4

XML schema-based view

definition, 10.1

XML search index

definition, 6.4

XML_DB_EVENTS parameter, 30.5

XML_ENABLE path section group attribute, 6.4.1

XMLAgg SQL function, 8.2.4

XMLAttributes SQL function, 8.2.1

XMLCast SQL function, 4.3.4

XMLCDATA SQL function, 8.2.11

XMLColAttVal SQL function, 8.2.10

XMLComment SQL function, 8.2.6

XMLConcat SQL function, 8.2.3

XMLElement SQL function, 8.2.1

XMLExists SQL function, 4.3.3

XMLEXTRA object column, 17.4.1.2

XMLForest SQL function, 8.2.2

XMLFormat

XMLAgg, 8.2.4, 8.4

XMLIndex

creating index, 6.3.5

dropping index, 6.3.5

order index

definition, 6.3.4

path index

definition, 6.3.4

path table, 6.3.4

renaming index, 6.3.5

structured component

definition, 6.3.2

synchronizing if ORA-08181, 6.3.14.1

unstructured component

definition, 6.3.2

value index

definition, 6.3.4

XMLIsValid SQL function, 7.2, 7.2.1.2.1

XMLNAMESPACES clause, 4.3.2

XMLOptimizationCheck SQL*Plus setting, 5.7.4

XMLOptimizationCheck SQL*Plus system variable, Preface, 5.7.4

XMLParse SQL function, 8.2.8

XMLPI SQL function, 8.2.5

XMLQuery SQL function, 4.3, 4.3.1

XMLRoot SQL function, 8.2.9

XMLSequence Oracle SQL function (deprecated), Preface

XMLSequence SQL function (deprecated), Preface

XMLSerialize SQL function, 8.2.7

XMLTable SQL function, 4.3, 4.3.2

breaking up an XML fragment, 3.6.6

column pattern

definition, 4.3.2

COLUMN_VALUE pseudo-column, 4.3.2

PASSING clause and FROM list order, 5.1.4

RETURNING SEQUENCE BY REF clause, 5.1.4

reverse node references in COLUMNS clause, 5.1.4

row pattern

definition, 4.3.2

XMLtransform SQL function, 7.1.1

XMLType

as abstract data type, 1.4.2

constructors, 3.5.1

DBMS_XMLDOM PL/SQL API, 11.2

DBMS_XMLPARSER PL/SQL API, 11.3

DBMS_XSLPROCESSOR PL/SQL API, 11.4

definition, 1.4.1

extracting data, 5.2

indexing columns, 6.2

instances, PL/SQL APIs, 11.1

loading data, 36.1

loading with SQL*Loader, 36.2

methods

createXML(), 11.1.1.3, 13.2.1

getCLOB(), 13.3

getNumberVal(), 4.1.1

getObject(), 13.2.1.2

getOPAQUE(), 13.2.1.2

getSchemaURL(), 17.2.4

insertXML(), 13.3

isSchemaBased(), 17.2.4

isSchemaValid(), 17.2.4

IsSchemaValid(), 7.2

isSchemaValidated(), 7.2, 17.2.4

schemaValidate(), 17.2.4

setObject(), 13.2.2

setSchemaValidated(), 7.2, 17.2.4

writeToStream(), 21.4.1.5

XML schema, 17.2.4

PL/SQL packages, 11.1

querying, 5.2

querying transient data, 5.2

querying XMLType columns, 5.2

queue payloads, 38.5.1

storage models, 1.4.2

table, querying with JDBC, 13.2.1.2

tables, views, columns, 17.4

views, access with PL/SQL DOM APIs, 11.2.6

XPath language

functions

ora:contains (Oracle), 4.5.1, E.5

syntax, 4.1.1