Skip Headers
Oracle® XML DB Developer's Guide
11
g
Release 2 (11.2)
E23094-03
Home
Book List
Contents
Master Index
Contact Us
Previous
PDF
·
Mobi
·
ePub
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.3
access control list (ACL)
child
definition,
27.4.4
constraining inheritance
definition,
27.4.4
definition,
27.1.4
extending inheritance
definition,
27.4.4
overview,
1.2.3.1
parent
definition,
27.4.4
system,
27.4.1
account XDB,
2.1
,
3.18.1
,
3.18.7.1
,
25.6
,
26.2
,
27.4
,
36.6.1
,
36.6.1
ACE
See
access control entry
ACL
See
access control list
ACLOID resource property
definition,
27.4
administering Oracle XML DB,
34
Advanced Queuing (AQ)
IDAP,
37.4
messaging scenarios,
37.1.1
point-to-point support,
37
publish/subscribe support,
37
XMLType queue payloads,
37.5.1
aggregate privilege
definition,
27.1.2
annotations
XML schema,
3.7.3
,
7.9
querying to obtain,
7.10
anonymous user, access to repository,
28.2.1
appendChildXML SQL function,
4.2.11
atomic privilege
definition,
27.1.2
attribute XML Schema data types
mapping to SQL,
7.12.2
attributes
Container,
21.3.2
xdb:columnProps,
7.9.3
xdb:defaultSchema,
7.3.7
xdb:defaultTable,
7.9.1
,
7.9.3
xdb:defaultTableSchema,
7.9.3
xdb:maintainDOM,
7.6.2
,
7.9.1
,
7.9.3
,
7.9.3
xdb:maintainOrder,
7.9.3
xdb:mapUnboundedStringToLob,
7.9.3
xdb:maxOccurs,
7.9.3
xdb:SQLCollSchema,
7.9.3
xdb:SQLCollType,
7.9.1
,
7.9.3
xdb:SQLInline,
7.9.3
,
9.3
,
9.3
xdb:SQLName,
7.9.1
,
7.9.3
xdb:SQLSchema,
7.9.3
,
7.9.3
xdb:SQLType,
7.9.1
,
7.9.3
,
7.9.3
,
9.7
xdb:srclang,
7.9.3
xdb:storeVarrayAsTable,
7.9.1
,
7.9.3
xdb:tableProps,
7.9.3
xdb:translate,
7.9.3
xsi:noNamespaceSchemaLocation,
7.1
,
19.3.1.1
authenticatedUser role
DBuri servlet security,
20.9.3
B
backward-compatible XML schema evolution
definition,
10.3.1
binary XML
definition,
1.3.3
Schema data types
mapping to SQL,
7.12.4
bootstrap ACL
definition,
27.4.1
B-tree index,
1.3.3
C
C API for XML,
16
CharacterData interface,
13.2.10
CheckIn event, repository,
30.2
CheckOut event, repository,
30.2
child ACL
definition,
27.4.4
circular dependencies
XML schemas,
9.9
CLASSPATH Java variable
setting,
31.3.1
CLOB storage of XML data
definition,
1.3.3
closeContext PL/SQL procedure,
14.2
collection
in out-of-line tables,
9.4
loading and retrieving large documents,
9.11
XML
definition,
7.8.1.3
collection attribute (SQL),
7.12.5
columnProps attribute,
7.9.3
complex XLink link
definition,
23.2.2
See also
extended XLink link
complexType
handling cycles,
9.9.2
handling inheritance,
9.8.1
mapping
any and anyAttribute declarations,
9.8.3
fragments to LOBs,
9.7
XML Schema data types to SQL,
7.12.5
Oracle XML DB restrictions and extensions,
9.8
component of a resource path name
definition,
21.2.1
compound XML document,
23.3
definition,
23.1
compression
for online transaction processing (OLTP)
using CREATE TABLE,
7.8.1.3
using XML schema annotations,
7.9.4.6
XMLType support,
1.3.3
,
B
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
constraining inheritance, ACLs
definition,
27.4.4
constraints on XMLType data,
7.8.2
repetitive XML elements,
9.2
contains SQL function,
6.2.2
contains XPath function (Oracle),
12.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 XML schema evolution,
10.2
copyEvolve PL/SQL procedure,
10
COST_XML_QUERY_REWRITE optimizer hint,
5.10.1
cost-based XML query rewrite
definition,
5.10.1
Create event, repository,
30.2
CREATE TABLE statement
encoding options for binary XML,
7.8.1.1
logging,
7.3.6
storage options,
7.8.1
XMLType,
3.2
storage as CLOB,
7.8.1.2
CREATE TYPE statement
logging,
7.3.6
createResource PL/SQL function,
3.4.6
createXML() XMLType method,
13.1.1.3
,
15.2.1
creating an XMLType table,
3.2
for nested collections,
3.7.7
storage options,
7.8.1
XML schema-based,
3.7.7
,
7.8
CTXCAT index,
12.4.5.1
CTXRULE index,
12.4.5.1
cyclical dependencies
XML schemas,
9.9
D
database role
definition,
27.1.1
,
27.1.1
,
27.1.1
database user
definition,
27.1.1
data-centric use of XML data
definition,
1.3.3
date and time XML Schema data types
mapping to SQL,
7.12.4
DAV: WebDAV namespace,
27.3
DBMS_METADATA PL/SQL package,
20.3.1
reference documentation,
1.2.1
,
1.2.1
DBMS_XDB PL/SQL package,
26.1
reference documentation,
1.2.1
,
1.2.1
DBMS_XDB_ADMIN PL/SQL package
reference documentation,
1.2.1
DBMS_XDB_VERSION PL/SQL package,
24
reference documentation,
1.2.1
DBMS_XDBT PL/SQL package,
1.2.1
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,
1.2.1
DBMS_XEVENT PL/SQL package
reference documentation,
1.2.1
DBMS_XMLDOM PL/SQL package,
13.2
examples,
13.2.12
reference documentation,
1.2.1
DBMS_XMLGEN PL/SQL package,
18.3
reference documentation,
1.2.1
DBMS_XMLINDEX PL/SQL package
modifyParameter procedure,
6.4.17.1
reference documentation,
1.2.1
registerParameter procedure,
6.4.17.1
DBMS_XMLPARSER PL/SQL package,
13.3
reference documentation,
1.2.1
DBMS_XMLQUERY PL/SQL package
Oracle Java Virtual Machine dependency,
B
DBMS_XMLSAVE PL/SQL package,
14.1
Oracle Java Virtual Machine dependency,
B
DBMS_XMLSCHEMA PL/SQL package,
7.3
copyEvolve procedure,
10
deleteSchema procedure,
7.3.13
generateSchema and generateSchemas functions,
9.1
inPlaceEvolve procedure,
10
mapping types,
7.12
purgeSchema procedure,
7.3.13.1
reference documentation,
1.2.1
registerSchema procedure,
7.3.1
,
9.10.3
enableHierarchy parameter,
29.2
DBMS_XMLSTORE PL/SQL package,
14
reference documentation,
1.2.1
DBMS_XSLPROCESSOR PL/SQL package,
13.4
reference documentation,
1.2.1
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.3
servlet, installation,
20.9.2
DBUri-refs,
20.6
HTTP access,
20.9
DBUriServlet
definition,
20.9
DBURIType
definition,
20.3
debugging
XML schema registration,
7.3.6
default tables
creating during XML schema registration,
7.3.8
defaultSchema attribute,
7.3.7
defaultTable attribute,
7.9.1
,
7.9.3
defaultTableSchema attribute,
7.9.3
definition,
10.3.1
Delete event, repository,
30.2
deleteSchema PL/SQL procedure,
7.3.13
deleteXML PL/SQL function,
14.1
deleteXML SQL function,
4.2.12
deleting
resource,
25.3.2
XML schema using DBMS_XMLSCHEMA,
7.3.13
depth SQL function,
25.2.4
derived XML Schema data types
mapping to SQL,
7.12.4
directory
See
folder
disable_hierarchy PL/SQL procedure,
27.7.1
document (DOM)
definition,
13.2.8
document link
definition,
21.3.3.1
,
23.2.1
obtaining information about,
23.6
document location hint
definition,
3.7.6
Document Object Model
See
DOM
Document Type Definition
See
DTD
document view serialization, JCR
definition,
31.2.3
DOCUMENT_LINKS public view,
23.6
document-centric use of XML data
definition,
1.3.3
document-correlated recursive query
definition,
9.10
,
9.10
DOM
definition,
13.1
difference from SAX,
13.2.1.3
document
definition,
13.2.8
fidelity,
7.6
,
7.6
for XML schema mapping,
13.2.5.1
SYS_XDBPD$ object attribute,
7.6.2
using SQL function updateXML,
4.2.3.3
Java API for XMLType,
15.1
NamedNodeMap object,
13.2.10
NodeList object,
13.2.10
overview,
13.2.1
PL/SQL API for XMLType,
13.2
DOM fidelity
definition,
7.6.1
DTD
definition,
7.2.2
support in Oracle XML DB,
7.2.2
use with Oracle XML DB,
7.2
dynamic type-checking
XQuery language,
5.11
E
effective text value of a node
definition,
6.4.4.2
element XML Schema data types
mapping to SQL,
7.12.3
elements
Contents, Resource index,
21.3
XDBBinary,
21.4.1.3
enable_hierarchy PL/SQL procedure,
27.7
,
27.7
enableHierarchy parameter, DBMS_XMLSCHEMA.registerSchema,
29.2
Enterprise Manager
administering Oracle XML DB,
34.3
entities, XML
using a DTD with binary XML storage,
7.2
equals_path SQL function,
5.10.5.1
,
25.2.2
equipartitioning of XMLType tables
definition,
9.5
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,
10
existsNode Oracle SQL function (deprecated),
Preface
extended XLink link
definition,
23.2.2
extending inheritance, ACLs
definition,
27.4.4
extract Oracle SQL function (deprecated),
Preface
extracting data from XML,
4.1.3
extractValue Oracle SQL function (deprecated),
Preface
F
fidelity
DOM,
7.6
for XML schema mapping,
13.2.5.1
SYS_XDBPD$ object attribute,
7.6.2
using SQL function updateXML,
4.2.3.3
FLWOR XQuery expression,
5.2.3
fn:available
support,
5.14.2.1
fn:collection
avoiding to improve performance,
5.10.5
support,
5.14.2
fn:doc
avoiding to improve performance,
5.10.5
support,
5.14.2
fn:id
support,
5.14.2
fn:idref
support,
5.14.2
fn:matches
support,
5.14.2
fn:replace
support,
5.14.2
fn:tokenize
support,
5.14.2
folder
definition,
21.2.1
,
21.2.1
folder link
definition,
21.3.3.1
folder sys, repository,
21.1
foldering,
21.1
folder-restricted query
definition,
3.18.13.2
fragment, XML
definition,
3.11.6
SQL operations on,
3.11.6
fragments, XML
mapping to LOBs,
9.7
freeDocument PL/SQL procedure,
13.2.12
freeing a DOMdocument instance,
13.2.12
FROM list order
XMLTable PASSING clause,
5.9.4
FTP
configuration parameters,
28.2.1
creating default tables,
7.3.8
protocol server, features,
28.3
fully qualified XML schema URLs,
9.6
functional evaluation
definition,
3.15
function-based index,
6.2.4.1
functions
PL/SQL
createResource,
3.4.6
deleteXML,
14.1
generateSchema and generateSchemas,
9.1
insertXML,
14.1
is_hierarchy_enabled,
29.7
updateXML,
14.1
SQL
appendChildXML,
4.2.11
contains,
6.2.2
deleteXML,
4.2.12
depth,
25.2.4
equals_path,
5.10.5.1
,
25.2.2
existsNode (deprecated),
Preface
extract (deprecated),
Preface
extractValue (deprecated),
Preface
insertChildXML,
4.2.6
insertChildXMLafter,
4.2.8
insertChildXMLbefore,
4.2.7
insertXMLafter,
4.2.10
insertXMLbefore,
4.2.9
path,
25.2.3
sys_DburiGen,
20.8
sys_XMLAgg,
18.5
sys_XMLGen,
18.4
under_path,
25.2.1
updateXML,
4.2.3
updating XML data,
4.2
XMLAgg,
18.2.4
XMLAttributes,
18.2.1
XMLCast,
4.1.2.2
XMLCDATA,
18.2.11
XMLColAttVal,
18.2.10
XMLComment,
18.2.6
XMLConcat,
18.2.3
XMLElement,
18.2.1
XMLExists,
4.1.2.1
XMLForest,
18.2.2
XMLIsValid,
3.9.1.2.1
,
11.3
XMLParse,
18.2.8
XMLPI,
18.2.5
XMLQuery,
5.3
,
5.3.1
XMLRoot,
18.2.9
XMLSequence (deprecated),
Preface
XMLSerialize,
18.2.7
XMLTable,
5.3
,
5.3.2
XMLtransform,
11.1.1
XPath
ora:instanceof (deprecated),
Preface
ora:instanceof-only (deprecated),
Preface
,
Preface
G
gatherRepositoryStats PL/SQL procedure,
26.2
generateSchema and generateSchemas PL/SQL functions,
9.1
generating XML,
18
DBMS_XMLGEN PL/SQL package,
18.3
DBMS_XMLSCHEMA PL/SQL package,
9.1
generateSchema and generateSchemas PL/SQL functions,
9.1
SQL functions,
18.1
sys_XMLAgg SQL function,
18.5
sys_XMLGen SQL function,
18.4
XML schemas,
9.1
XMLAgg SQL function,
18.2.4
XMLAttributes SQL function,
18.2.1
XMLCDATA SQL function,
18.2.11
XMLColAttVal SQL function,
18.2.10
XMLComment SQL function,
18.2.6
XMLConcat SQL function,
18.2.3
XMLElement SQL function,
18.2.1
XMLForest SQL function,
18.2.2
XMLParse SQL function,
18.2.8
XMLPI SQL function,
18.2.5
XMLRoot SQL function,
18.2.9
XMLSerialize SQL function,
18.2.7
getBLOBVal() Oracle XMLType method (deprecated),
Preface
getCLOB() XMLType method,
15.3
getCLOBVal() Oracle XMLType method (deprecated),
Preface
getNamespace() Oracle XMLType method (deprecated),
Preface
getNumberVal() XMLType method,
4.1.1
getObject() XMLType method,
15.2.1.2
getOPAQUE() XMLType method,
15.2.1.2
getRootElement() Oracle XMLType method (deprecated),
Preface
getSchemaURL() XMLType method,
7.4
getStringVal() Oracle XMLType method (deprecated),
Preface
getting JCR repository objects,
31.3.2
global XML schema
definition,
7.5.2
using fully qualified URL to override,
9.6
grants declared in an ACL
definition,
27.4.4
grants defined for an ACL
definition,
27.4.4
group in an XMLIndex structured component
definition,
6.4.7
H
hard link
definition,
21.3.3.2
JCR,
31.2.6
hierarchical repository index,
3.18.14
hierarchy-enabled table
definition,
27.7
HTTP
access for DBUri-refs,
20.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,
7.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.4
using UriRefs to store pointers,
20.3
HTTPUri
definition,
20.3
HTTPURIType
definition,
20.3
hybrid columnar compression,
B
hybrid storage
definition,
6.2.1
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.18.14
indexing
CTXCAT,
12.4.5.1
CTXRULE,
12.4.5.1
function-based,
6.2.4.1
options for XMLType,
3.1.2
Oracle Text,
1.4.4
,
6.5
,
12
XMLType,
6.2
index-organized tables,
3.7.4
inheritance
XML schema, restrictions in complexTypes,
9.8.1
in-place XML schema evolution,
10.3
inPlaceEvolve PL/SQL procedure,
10
insertChildXML SQL function,
4.2.6
insertChildXMLafter SQL function,
4.2.8
insertChildXMLbefore SQL function,
4.2.7
insertXML PL/SQL function,
14.1
insertXML() XMLType method,
15.3
insertXMLafter SQL function,
4.2.10
insertXMLbefore SQL function,
4.2.9
installing Oracle XML DB,
34.1
instance document
definition,
1.3.2
specifying root element namespace,
7.1
Internet Data Access Presentation (IDAP)
SOAP specification for AQ,
37.4
Internet Protocol Version 6
FTP,
28.3.1.6
HTTP(S),
28.4.1.4
IPv6
FTP,
28.3.1.6
HTTP(S),
28.4.1.4
is_hierarchy_enabled PL/SQL function,
29.7
isSchemaBased() XMLType method,
7.4
isSchemaValid() XMLType method,
7.4
IsSchemaValid() XMLType method,
11.3
isSchemaValidated() XMLType method,
7.4
,
11.3
J
Java
connections, thick and thin,
15.4
DOM API for XMLType,
15.1
Oracle XML DB applications,
32.1
oracle.xml.parser.v2,
15.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() 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,
15.2.1.2
drivers, OCI and thin,
15.2.2
loading large XML documents,
15.3
manipulating XML documents,
15.2.2
JSR-170
See
JCR 1.0
L
large node handling,
13.2.13
lazy XML loading (lazy manifestation),
13.1.1.1
link
document
definition,
21.3.3.1
folder
definition,
21.3.3.1
hard
definition,
21.3.3.2
repository
definition,
21.3.3.1
weak
definition,
21.3.3.2
link name
definition,
21.2.1
LinkIn event, repository,
30.2
linking, repository
definition,
3.18.13.1
link-properties document
definition,
3.18.13.1
LinkTo event, repository,
30.2
loading
large documents with collections,
9.11
loading large XML documents using JDBC,
15.3
loading of XML data, lazy,
13.1.1.1
LOB locator,
24.4
LOBs
mapping XML fragments to,
9.7
local XML schema
definition,
7.5.1
using fully qualified URL to specify,
9.6
Lock event, repository,
30.2
M
maintainDOM attribute,
7.6.2
,
7.9.1
,
7.9.3
,
7.9.3
maintainOrder attribute,
7.9.3
manifestation, lazy,
13.1.1.1
mapping
complexType any and anyAttributes declarations,
9.8.3
complexType to SQL
out-of-line storage,
9.3
overriding using SQLType attribute,
7.12.3.1
simpleContent to object types,
9.8.2
mapping XML Schema complexType data types to SQL,
7.12.5
mapping XML Schema data types to SQL data types,
7.12
mapping XML Schema to SQL
simpleType,
7.12.4
mapUnboundedStringToLob attribute,
7.9.3
matches XQuery function (Oracle),
5.7.2
maxOccurs attribute,
7.9.3
metadata
definition,
29.1
system-defined
definition,
1.2.3
user-defined
definition,
1.2.3
methods
XMLType
createXML(),
13.1.1.3
,
15.2.1
getBLOBVal() (deprecated),
Preface
getCLOB(),
15.3
getCLOBVal() (deprecated),
Preface
getNamespace() (deprecated),
Preface
getNumberVal(),
4.1.1
getObject(),
15.2.1.2
getOPAQUE(),
15.2.1.2
getRootElement() (deprecated),
Preface
getSchemaURL(),
7.4
getStringVal() (deprecated),
Preface
insertXML(),
15.3
isSchemaBased(),
7.4
isSchemaValid(),
7.4
IsSchemaValid(),
11.3
isSchemaValidated(),
7.4
,
11.3
schemaValidate(),
7.4
setObject(),
15.2.2
setSchemaValidated(),
7.4
,
11.3
writeToStream(),
21.4.1.5
XML schema,
7.4
MIME
overriding with DBUri servlet,
20.9.1
mix:referenceable,
31.2.3
mixed XML content
definition,
1.3.3
model, XML Schema
definition,
10.3.1.1.4
modifyParameter PL/SQL procedure,
6.4.17.1
N
NamedNodeMap object (DOM),
13.2.10
namespace
prefixes
ocjr,
31.2.2
URL for XML schema,
7.1
XQuery,
5.5
,
5.9.5
naming SQL objects,
7.9
navigational access to repository resources,
21.4
nested XML
generating using DBMS_XMLGEN,
18.3.3
generating with XMLElement,
18.2.1.3
NESTED_TABLE_ID pseudocolumn,
3.7.7
newDOMDocument() function,
13.2.9
NodeList object (DOM),
13.2.10
nodes, large (DBMS_XMLDOM),
13.2.13
nodes, large (Java),
15.6
noNamespaceSchemaLocation attribute,
7.1
,
19.3.1.1
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
numeric XML Schema data types
mapping to SQL,
7.12.4
O
object attributes
for collection (SQL),
7.12.5
of XMLFormat,
18.4.2
REF,
9.3
,
9.9.2
sys_DburiGen SQL function
passing to,
20.8.1
SYS_XDBPD$,
7.6.2
XMLType, in AQ,
37.5.1
object identifier
definition,
27.4
OBJECT_ID column of XDB$ACL table,
27.4
object-based persistence of XML data
definition,
1.3.3
object-relational storage of XML data
definition,
1.3.3
occurrence indicator
definition,
5.2.2
OCI API for XML,
16
ocjr namespace prefix,
31.2.2
OCT
definition,
3.7.4
ODP.NET,
17
OID
See
object identifier
ojcr:folder,
31.2.3
operator
See
functions, SQL
optimizer hints
COST_XML_QUERY_REWRITE,
5.10.1
optimizing repository queries,
26.2
ora:contains XPath function (Oracle),
12.5
policy
definition,
12.5.4
ora:defaultTable XQuery pragma,
5.8
,
5.10.5.2
ora:instanceof Oracle XPath function (deprecated),
Preface
ora:instanceof-only Oracle XPath function (deprecated),
Preface
,
Preface
ora:invalid_path XQuery pragma,
5.8
ora:matches XQuery function (Oracle),
5.7.2
ora:replace XQuery function (Oracle),
5.7.3
ora:sqrt XQuery function (Oracle),
5.7.4
ora:tokenize XQuery function (Oracle),
5.7.5
ora:view_on_null XQuery pragma,
5.8
ora:xq_proc XQuery pragma,
5.8
,
6.4.9
ora:xq_qry XQuery pragma,
5.8
Oracle ASM files
accessing,
21.4.2
using FTP,
28.3.1.4
Oracle ASM virtual folder,
21.3.1.3
Oracle Data Provider for .NET,
17
Oracle Enterprise Manager
administering Oracle XML DB,
34.3
Oracle extensions to JCR node types,
31.2.2
Oracle Internet Directory,
27.8
Oracle Net Services,
1.2
Oracle Text
contains SQL function and XMLType,
6.2.2
index,
1.4.4
,
6.5
,
12
searching for resources,
25.6
searching XML in CLOB instances,
1.4.4
Oracle XML DB
access models,
2.3.2
advanced queuing,
1.4.4
architecture,
1.2
features,
1.3
installation,
34.1
Java applications,
32.1
overview,
1.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
See also
JCR
OracleRepository,
31.3.2
oracle.xdb.XMLType Java class,
15.1
,
15.4.1.1
oracle.xml.parser.v2 Java package,
15.1
order index of XMLIndex
definition,
6.4.4
ordered collection
definition,
3.7.4
ordered collection table (OCT)
definition,
3.7.4
ordered collections in tables (OCTs)
default storage of varray,
7.12.5
out-of-line storage,
9.3
collections,
9.4
XPath rewrite,
9.3.1
P
parent ACL
definition,
27.4.4
partial update of XML data
definition,
4.2.2
partial validation of XML data
definition,
3.9.1.1
partitioning XMLType tables,
9.5
binary XML,
3.3
PASSING clause of XMLTable
FROM list order,
5.9.4
path component of a resource path name
definition,
21.2.1
path index of XMLIndex
definition,
6.4.4
path name
definition,
21.2.1
resolution,
21.3.2
path SQL function,
25.2.3
path table of XMLIndex,
6.4.4
PATH_VIEW,
25
path-based access to repository resources,
21.4
path-index trigger
definition,
27.7
PD (positional descriptor),
7.6.2
persistence models for XML data,
1.3.3
PL/SQL functions
See
functions, PL/SQL
PL/SQL packages
DBMS_METADATA,
20.3.1
reference documentation,
1.2.1
,
1.2.1
DBMS_XDB,
26.1
reference documentation,
1.2.1
,
1.2.1
DBMS_XDB_ADMIN
reference documentation,
1.2.1
DBMS_XDB_VERSION,
24
reference documentation,
1.2.1
DBMS_XDBT,
1.2.1
DBMS_XDBZ,
27.7
,
29.7
reference documentation,
1.2.1
DBMS_XEVENT
reference documentation,
1.2.1
DBMS_XMLDOM,
13.2
reference documentation,
1.2.1
DBMS_XMLGEN,
18.3
reference documentation,
1.2.1
DBMS_XMLINDEX
reference documentation,
1.2.1
DBMS_XMLPARSER,
13.3
reference documentation,
1.2.1
DBMS_XMLQUERY
Oracle Java Virtual Machine dependency,
B
DBMS_XMLSAVE,
14.1
Oracle Java Virtual Machine dependency,
B
DBMS_XMLSCHEMA
reference documentation,
1.2.1
See
DBMS_XMLSCHEMA PL/SQL package
DBMS_XMLSTORE,
14
reference documentation,
1.2.1
DBMS_XSLPROCESSOR,
13.4
reference documentation,
1.2.1
for XMLType,
13.1
PL/SQL procedures
See
procedures, PL/SQL
point-to-point
support in AQ,
37
policy for ora:contains XPath function (Oracle)
definition,
12.5.4
ports
configuring
FTP,
28.2.1
HTTP,
28.2.1
HTTPS,
28.2.2
positional descriptor (PD),
7.6.2
post-parse persistence of XML data
definition,
1.3.3
pragmas
XQuery
Oracle,
5.8
predefined ACLs,
27.4.1
preference
Oracle Text indexing
definition,
12.4.5.1
pretty-printing,
18.2.7
in book examples,
Preface
not done by SQL/XML functions,
3.16.1
Web service output,
33.3
primitive XML Schema data types
mapping to SQL,
7.12.4
principal
definition,
27.1.1
,
27.1.1
private (local) XML schema, definition,
7.5
privilege
definition,
27.1.2
procedures
PL/SQL
closeContext,
14.2
copyEvolve,
10
disable_hierarchy,
27.7.1
enable_hierarchy,
27.7
,
27.7
freeDocument,
13.2.12
gatherRepositoryStats,
26.2
inPlaceEvolve,
10
modifyParameter,
6.4.17.1
processXSL,
13.4.3
purgeLDAPCache,
27.6
registerParameter,
6.4.17.1
registerSchema,
7.3.1
setKeyColumn,
14.2
setUpdateColumn,
14.2
processXSL PL/SQL procedure,
13.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.4.1
public (global) XML schema, definition,
7.5
publish/subscribe
support in AQ,
37
purchase-order XML document
used in full-text examples,
12.7.1
purchase-order XML schema,
3.6.4.1
annotated,
3.7.5
,
A.6
graphical representation,
3.6.4.2
revised,
10.2.1
,
A.6
purgeLDAPCache PL/SQL procedure,
27.6
purgeSchema PL/SQL procedure,
7.3.13.1
Q
qualified XML schema URLs,
9.6
query-based access to resources
using RESOURCE_VIEW and PATH_VIEW,
25.1
using SQL,
21.5
querying XMLType data
choices,
4.1
transient data,
4.1.3
R
ra:use_text_index Oracle XQuery pragma,
12.5.5.2
recursive schema support,
9.10
REF object attribute,
9.3
,
9.9.2
REGISTER_NT_AS_IOT option for XML schema registration,
3.7.4
,
3.7.4
,
7.3.1
registered XML schemas, list of,
7.3.12
registering an XML schema,
7.3.1
debugging,
7.3.6
default tables, creating,
7.3.8
SQL object types, creating,
7.3.7
registering an XML schema for JCR,
31.4.1
registerParameter PL/SQL procedure,
6.4.17.1
registerSchema PL/SQL procedure,
7.3.1
renaming an XMLIndex index,
6.4.5
Render event, repository,
30.2
replace XQuery function (Oracle),
5.7.3
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,
3.18.14
resource
See
resource
use with XQuery,
5.9.2
repository link
definition,
21.3.3.1
repository objects,
31.3.2
RESID
definition,
24.2
resource
access,
21.1.1
using protocols,
28.2.3
definition,
1.2.3
,
29.1
deleting,
21.3.3.2
nonempty container,
25.3.2.1
using DELETE,
25.3.2
managing with DBMS_XDB,
26.2
,
34.5
required privileges for operations,
27.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.18.7.1
resource ID
definition,
24.2
resource name
definition,
21.2.1
resource version
definition,
24.1
RESOURCE_VIEW
explained,
25
resource-view-cache-size configuration parameter,
25.5
retrieving large documents with collections,
9.11
rewrite
XPath (XPath),
8
XQuery,
5.10
role
authenticatedUser, DBuri servlet,
20.9.3
database
definition,
27.1.1
XDB_SET_INVOKER,
30.5.1
XDBADMIN,
7.5.2
,
22.1
,
27.4.1
,
30.5
root folder, repository,
21.1
root XML Schema
definition,
7.3.5
rule-based XML query rewrite
definition,
5.10.1
S
scalar value
converting to XML document using sys_XMLGen,
18.4.2
schema evolution
See
XML schema evolution
schema for schemas (XML Schema)
definition,
1.3.2
schema location hint
definition,
3.7.6
schemaValidate() XMLType method,
7.4
searching CLOB instances,
1.4.4
security
DBUri,
20.9.3
semi-structured XML data
definition,
1.3.3
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,
14.2
setObject() XMLType method,
15.2.2
setSchemaValidated() XMLType method,
7.4
,
11.3
setUpdateColumn PL/SQL procedure,
14.2
simple XLink link
definition,
23.2.2
simpleContent
mapping to object types,
9.8.2
simpleType XML Schema data types
mapping to SQL,
7.12.4
SOAP,
33.1
access through Advanced Queuing,
1.2
IDAP,
37.4
SQL function
See
functions, SQL
SQL functions
See
functions, SQL
SQL object types
creating during XML schema registration,
7.3.7
SQL operator
See
functions, SQL
SQL*Loader,
35.2
SQL*Plus
XQUERY command,
5.12
SQLCollSchema attribute,
7.9.3
SQLCollType attribute,
7.9.1
,
7.9.3
SQLInline attribute,
7.9.3
,
9.3
,
9.3
SQLJ,
15.4.1.1
SQLName attribute,
7.9.1
,
7.9.3
SQLSchema attribute,
7.9.3
,
7.9.3
SQLType attribute,
7.9.1
,
7.9.3
,
7.9.3
,
9.7
SQL/XML generation functions
definition,
1.3.5
SQL/XML publishing functions
definition,
1.3.5
,
18.2
SQL/XML query and access functions
definition,
1.3.5
SQL/XML standard
generating XML data,
18.2
querying XML data
XMLExists and XMLCast,
4.1.2
XMLQuery and XMLTable,
5.3
sqrt XQuery function (Oracle),
5.7.4
srclang attribute,
7.9.3
standard metadata,
31.2.4
static type-checking
XQuery language,
5.11
storage
out of line,
9.3
collections,
9.4
XMLType, CREATE TABLE,
7.8.1.2
storage models for XMLType,
1.3.3
storeVarrayAsTable attribute,
7.9.1
,
7.9.3
string XML Schema data types
mapping to SQL,
7.12.4
mapping to VARCHAR2 vs CLOB,
7.12.4.2
structured storage of XML data
definition,
1.3.3
structured XMLIndex component
definition,
6.4.2
style sheet for updating XML instance documents,
10.2.5
sys folder, repository,
21.1
sys_DburiGen SQL function,
20.8
inserting database references,
20.8.2
retrieving object URLs,
20.8.2.2
,
20.8.2.2
use with text node test,
20.8.1
SYS_NC_ARRAY_INDEX$ column,
3.7.7
SYS_XDBPD$ object attribute,
7.6.2
sys_XMLAgg SQL function,
18.5
sys_XMLGen SQL function,
18.4
converting XMLType instances,
18.4.2
object views,
18.4.2
XMLFormat object attributes,
18.4.2
XMLGenFormatType object,
18.4.2
SYSAUX tablespace,
34.1.1
system ACL
definition,
27.4.1
system ACLs,
27.4.1
system-defined metadata
definition,
1.2.3
T
tableProps attribute,
7.9.3
tables
index-organized,
3.7.4
tablespace
SYSAUX,
34.1.1
text value of a node, effective
definition,
6.4.4.2
text-based persistence of XML data
definition,
1.3.3
third-party XLink link
definition,
23.2.2
tokenize XQuery function (Oracle),
5.7.5
translate attribute,
7.9.3
trigger, path-index
definition,
27.7
type-checking, static and dynamic
XQuery language,
5.11
U
UDT
generating an element from,
18.2.1.3
UncheckOut event, repository,
30.2
under_path SQL function,
25.2.1
uniform access control mechanism
definition,
27.7
unique constraint on parent element of an attribute,
9.2
UnLinkIn event, repository,
30.2
Unlock event, repository,
30.2
unresolved XLink and XInclude links,
23.7.1
unstructured storage of XML data
definition,
1.3.3
unstructured XMLIndex component
definition,
6.4.2
Update event, repository,
30.2
updateXML PL/SQL function,
14.1
updateXML SQL function,
4.2.3
mapping NULL values,
4.2.3.1
updating repository resource,
25.3.3
updating XML data
partial update
definition,
4.2.2
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.4
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
definition,
27.1.1
user XDB,
2.1
,
3.18.1
,
3.18.7.1
,
25.6
,
26.2
,
27.4
,
36.6.1
,
36.6.1
user-defined metadata,
31.2.5
definition,
1.2.3
V
validating
examples,
11.4
IsSchemaValid() XMLType method,
11.3
isSchemaValidated() XMLType method,
11.3
setSchemaValidated() XMLType method,
11.3
XMLIsValid SQL function,
11.3
use as CHECK constraint,
3.9.1.2.1
validation of XML data, partial
definition,
3.9.1.1
value index of XMLIndex
definition,
6.4.4
varray in a LOB
definition,
3.7.4
varray in a table
definition,
3.7.4
VCR
See
version-controlled resource
version resource
definition,
24.1
version series of a resource
definition,
24.2
versionable resource
definition,
24.1
VersionControl event, repository,
30.2
version-controlled resource
definition,
24.1
versioning,
1.2.3.1
,
24
views
RESOURCE and PATH,
25
W
weak link
definition,
21.3.3.2
deletion,
23.7.1
JCR,
31.2.6
Web service,
33.1
pretty-printing output,
33.3
WebDAV protocol server,
28.5
WebFolder
creating in Windows 2000,
28.5.3
well-formed XML document
definition,
3.9
writeToStream() XMLType method,
21.4.1.5
WSDL
Web service for accessing stored PL/SQL,
33.4
Web service for database queries,
33.3
X
XDB database schema (user account),
2.1
,
3.18.1
,
3.18.7.1
,
25.6
,
26.2
,
27.4
,
36.6.1
,
36.6.1
xdb namespace,
27.3
XDB$ACL table,
27.4
xdb:columnProps attribute,
7.9.3
xdb:defaultSchema attribute,
7.3.7
xdb:defaultTable attribute,
7.9.1
,
7.9.3
xdb:defaultTableSchema attribute,
7.9.3
xdb:maintainDOM attribute,
7.6.2
,
7.9.1
,
7.9.3
,
7.9.3
xdb:maintainOrder attribute,
7.9.3
xdb:mapUnboundedStringToLob attribute,
7.9.3
xdb:maxOccurs attribute,
7.9.3
xdb:SQLCollSchema attribute,
7.9.3
xdb:SQLCollType attribute,
7.9.1
,
7.9.3
xdb:SQLInline attribute,
7.9.3
,
9.3
,
9.3
xdb:SQLName attribute,
7.9.1
,
7.9.3
xdb:SQLSchema attribute,
7.9.3
,
7.9.3
xdb:SQLType attribute,
7.9.1
,
7.9.3
,
7.9.3
,
9.7
xdb:srclang attribute,
7.9.3
xdb:storeVarrayAsTable attribute,
7.9.1
,
7.9.3
xdb:tableProps attribute,
7.9.3
xdb:translate attribute,
7.9.3
XDB_SET_INVOKER role,
30.5.1
XDBADMIN role,
7.5.2
,
22.1
,
27.4.1
,
27.4.1
,
30.5
XDBBinary element,
21.4.1.3
definition,
21.2.1
xdbconfig.xml configuration file,
34.4
xdbcore parameters,
9.11.1
xdbcore-loadableunit-size configuration parameter,
9.11
,
25.5
xdbcore-xobmem-bound configuration parameter,
9.11
,
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
,
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 attributes
See
attributes
XML diagnosability mode,
5.10.4
XML entities
using a DTD with binary XML storage,
7.2
XML fragment
definition,
3.11.6
mapping to LOBs,
9.7
SQL operations on,
3.11.6
XML instance document
definition,
1.3.2
XML Object (XOB),
2.4.2
XML query rewrite
definition,
5.10
cost-based,
5.10.1
rule-based,
5.10.1
XML schema
annotations,
3.7.3
,
7.9
querying to obtain,
7.10
circular dependencies,
9.9
complexType declarations,
9.8.1
,
9.9.2
cyclical dependencies,
9.9
definition,
1.3.2
,
7.1
deletion,
7.3.13
evolution,
10
backward-compatible,
10.3.1
for XML schemas that can be registered,
7.3.5
generating from object-relational type,
9.1
inheritance in, complexType restrictions,
9.8.1
local and global,
7.5
managing and storing,
7.3.5
mapping to SQL object types,
13.2.5
registration with Oracle XML DB,
7.3.1
for use with JCR,
31.4.1
updating after registering,
10
URLs,
9.6
use with JCR,
31.4
use with Oracle XML DB,
7.2
W3C Recommendation,
3.6
,
7
XMLType methods,
7.4
XML Schema
definition,
Preface
XML Schema data types
mapping to JCR node types,
31.4.3
mapping to SQL data types,
7.12
XML schema definition
definition,
1.3.2
XML schema evolution
copy-based,
10.2
in-place,
10.3
XML schema-based tables and columns, creating,
7.8
XML schema-based view
definition,
19.1
XML_DB_EVENTS parameter,
30.5
XMLAgg SQL function,
18.2.4
XMLAttributes SQL function,
18.2.1
XMLCast SQL function,
4.1.2.2
XMLCDATA SQL function,
18.2.11
XMLColAttVal SQL function,
18.2.10
XMLComment SQL function,
18.2.6
XMLConcat SQL function,
18.2.3
XMLElement SQL function,
18.2.1
XMLExists SQL function,
4.1.2.1
XMLEXTRA object column,
9.9.2.1
XMLForest SQL function,
18.2.2
XMLFormat
XMLAgg,
18.2.4
,
18.5
XMLFormat object type
sys_XMLGen
XMLFormatType object,
18.4.2
XMLGenFormatType object,
18.4.2
XMLIndex
creating index,
6.4.5
dropping index,
6.4.5
order index
definition,
6.4.4
path index
definition,
6.4.4
path table,
6.4.4
renaming index,
6.4.5
structured component
definition,
6.4.2
unstructured component
definition,
6.4.2
value index
definition,
6.4.4
XMLIsValid SQL function,
3.9.1.2.1
,
11.3
XMLOptimizationCheck SQL*Plus setting,
5.10.4
XMLOptimizationCheck SQL*Plus system variable,
Preface
,
5.10.4
XMLParse SQL function,
18.2.8
XMLPI SQL function,
18.2.5
XMLQuery SQL function,
5.3
,
5.3.1
XMLRoot SQL function,
18.2.9
XMLSequence Oracle SQL function (deprecated),
Preface
XMLSerialize SQL function,
18.2.7
XMLTable SQL function,
5.3
,
5.3.2
breaking up an XML fragment,
3.11.6
breaking up multiple levels of XML data,
3.12.2
PASSING clause and FROM list order,
5.9.4
XMLtransform SQL function,
11.1.1
XMLType
as abstract data type,
1.3.3
benefits,
3.1.2
constructors,
3.4.1
contains SQL function,
6.2.2
CREATE TABLE statement,
7.8.1.2
DBMS_XMLDOM PL/SQL API,
13.2
DBMS_XMLPARSER PL/SQL API,
13.3
DBMS_XSLPROCESSOR PL/SQL API,
13.4
definition,
1.3.1
extracting data,
4.1.3
indexing columns,
6.2
instances, PL/SQL APIs,
13.1
loading data,
35.1
loading with SQL*Loader,
35.2
methods
createXML(),
13.1.1.3
,
15.2.1
getCLOB(),
15.3
getNumberVal(),
4.1.1
getObject(),
15.2.1.2
getOPAQUE(),
15.2.1.2
getSchemaURL(),
7.4
insertXML(),
15.3
isSchemaBased(),
7.4
isSchemaValid(),
7.4
IsSchemaValid(),
11.3
isSchemaValidated(),
7.4
,
11.3
schemaValidate(),
7.4
setObject(),
15.2.2
setSchemaValidated(),
7.4
,
11.3
writeToStream(),
21.4.1.5
XML schema,
7.4
PL/SQL packages,
13.1
querying,
4.1
querying transient data,
4.1.3
querying XMLType columns,
4.1.3
queue payloads,
37.5.1
storage models,
1.3.3
table, querying with JDBC,
15.2.1.2
tables, views, columns,
7.8
views, access with PL/SQL DOM APIs,
13.2.6
XOB,
2.4.2
XPath language
functions
ora:contains (Oracle),
5.7.1
,
12.5
syntax,
4.1.1
See also
XQuery language
XPath rewrite,
8
,
8
definition,
5.10
indexes on singleton elements and attributes,
6.3.1
out-of-line storage,
9.3.1
XQuery
extension expressions,
5.8
pragmas
Oracle,
5.8
pragmas, Oracle
ora:use_text_index,
12.5.5.2
XQUERY command, SQL*Plus,
5.12
XQuery functions and operators
support,
5.14.2
XQuery language,
5
expressions,
5.2.2
FLWOR,
5.2.3
rewrite,
5.10
functions
ora:contains (Oracle),
5.7.1
,
12.5
ora:matches (Oracle),
5.7.2
ora:replace (Oracle),
5.7.3
ora:sqrt (Oracle),
5.7.4
ora:tokenize (Oracle),
5.7.5
item
definition,
5.2.1
namespaces,
5.5
,
5.9.5
optimization,
5.10
optimization over relational data,
5.10.2
Oracle extension functions,
5.7
Oracle XML DB support,
5.14
performance,
5.10
predefined namespaces and prefixes,
5.5
referential transparency
definition,
5.2.1
sequence
definition,
5.2.1
SQL*Plus XQUERY command,
5.12
tuning,
5.10
type-checking, static and dynamic,
5.11
unordered mode
definition,
5.2.1
use with Oracle XML DB Repository,
5.9.2
use with XMLType relational data,
5.9.4
optimization,
5.10.3
XMLQuery and XMLTable SQL functions,
5.3
examples,
5.9
XSD
definition,
1.3.2
xsi:noNamespaceSchemaLocation attribute,
7.1
,
19.3.1.1
XSL style sheet
definition,
13.4
XSLT
style sheets
for updating XML instance documents,
10.2.5
use with DBUri servlet,
3.19.1
,
3.20
use with Oracle XML DB,
3.17
use with package DBMS_XSLPROCESSOR,
13.4.3
Scripting on this page enhances content navigation, but does not change the content in any way.