Skip Headers

Oracle9i XML Database Developer's Guide - Oracle XML DB
Release 2 (9.2)

Part Number A96620-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
View PDF

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 entries (ACEs), 18-10
elements in, 18-6
access control lists (ACLs), 18-2
bootstrap, 18-4
concurrency resolution, 18-5
default, 18-4
defined, 13-5
features, 18-5
managing, 18-12
managing from Enterprise Manager, 21-22
restrictions, 18-13
security, row-level, 18-14
setting the resource property, 18-12
summary, 1-11
term explained, 1-29
updating, 18-11
using, 18-10
accessing
using XDBUriType, 3-44
with JDBC, 9-3
XML documents using Java, 9-2
adding
XMLType columns, 4-8
Advanced Queuing (AQ)
definition, 24-2
enqueuing, 24-10
hub-and-spoke architecture support, 24-4
IDAP, 24-7
message management support, 24-4
messaging scenarios, 24-2
point-to-point support, 24-2
publish/subscribe support, 24-2
XML servlet, 24-13
XMLType queue payloads, 24-8
aggregating
XSQL and XMLAgg, 10-52
ALTER INDEX, using sections, 7-10
any, 13-6
attributes
collection, 5-37
columnProps, 5-70
Container, 13-7
defaultTable, 5-70
for root element, 3-21
in elements, 5-25
maintainDOM, 5-22
maintainOrder, 5-37
mapping any, 5-45
maxOccurs, 5-37
namespaces, 5-5
noNameSpaceSchemaLocation, 3-22
of XMLFormat, 10-44
passing to SYS_DBURIGEN, 12-30
REF, 5-38, 5-47
schemaLocation, 3-22, 5-10
setting to NULL, 4-36
SQLInLine, 5-37, 5-38
SQLName, 5-24
SQLSchema, 5-24
SQLType, 5-24, 5-28, 5-39
storeVarrayAsTable, 5-71
SYS_XDBPD$, 5-57
tableProps, 5-70
xdb.defaultTable, 3-40
xdb.SQLType, 3-31
XMLAttributes in XMLElement, 10-7
XMLDATA, 4-13, 5-50
XMLType, in AQ, 24-8
xsi.NamespaceSchemaLocation, 5-5
xsi.noNamespaceSchemaLocation, 11-9
authenticatedUser
DBuri security, 12-37
AUTO_SECTION_GROUP
using, 7-10

B

B*Tree, 1-11, 4-6, 5-51
indexing, 3-26
bootstrap ACL, 18-4

C

CASCADE mode, 5-14
cascading style sheets, see CSS, D-5
catalog views, F-19
cfg_get, 16-9, A-14
cfg_refresh, A-15
character sets
importing and exporting XML data, 23-6
Korean, 3-4
CharacterData, 8-23
CLOB storage of XMLType, 4-5
collection attribute, 5-37
collection index, 5-60
collections, 3-32, 18-6
columnProps attribute, 5-70
complexType
collections, 3-32
cycling, 5-48
cycling between, 5-46
elements, B-3
handling inheritance, 5-41
in XML schema, explained, B-35
mapping any and any attributes, 5-45
mapping to SQL, 5-37
restrictions, 5-41
concatenating
elements using XMLConcat, 10-16
configuring
API, A-14
protocol server in Oracle XML DB, 19-4
servlet, example, 20-12
servlets in Oracle XML DB, 20-4
using Enterprise Manager, 21-7
constraints
on XMLType columns, 5-51
structured storage, 3-33
using with XMLType tables, 3-23
CONTAINS, 4-39, 7-6
compared against existsNode, 7-38
compared to existsNode(),extract(), 4-42
contents, element, 13-6
CREATE TABLE
XMLType storage, 5-50
createFolder(), 16-3
createXML
inserting with CLOB, example, 4-15
inserting with string, 4-16
summarized, 3-17
creating
XML schema-based tables, columns, 5-22
XMLType columns, 4-8
XMLType table, 4-7
CSS and XSL, D-5
CTX_DDL.Add_Field_Section, 7-26
CTXAPP
role, 7-6
CTXSYS.PATH_SECTION_GROUP, 7-36
CTXXPATH, 4-41
indexes, 7-45
storage preferences, 7-47
cycling in complexTypes
self-referencing, 5-48

D

data integrity
in structured, unstructured storage, 3-27
Oracle XML DB, 3-33
date
format conversion in updateXML(), 5-70
format conversions for XML, 5-62
mapping to SQL, 5-35
DBMS_METADATA, 12-5
DBMS_XDB, F-20
AclCheckPrivileges, database objects, 18-13
cfg_get, A-14
cfg_refresh, A-15
changePrivilege, 18-13
checkPrivileges, 18-13
configuration management, 16-8
getAclDocument, 18-13
Link, 16-2
LockResource, 16-2
overview, 16-2
rebuilding hierarchical index, 16-11
security, 16-5
DBMS_XDB_VERSION, 14-2, F-25
subprograms, 14-9
DBMS_XDBT, F-27
DBMS_XMLDOM, 8-5, 8-11, F-6
DBMS_XMLGEN, 10-21, F-23
generating complex XML, 10-30
generating XML, 10-2
DBMS_XMLPARSER, 8-26, F-14
DBMS_XMLSCHEMA, 5-8, F-16
deleteSchema, 5-8
generateSchema() function, 5-17
generateSchemas() function, 5-17
mapping of types, 5-31
registerSchema, 5-8
DBMS_XSLPROCESSOR, 8-30, F-15
dbmsxsch.sql, F-16
DBUri, 12-10
and object references, 12-18
identifying a row, 12-16
identifying a target column, 12-16
retrieving column text value, 12-17
retrieving the whole table, 12-15
security, 12-37
servlet, 12-34
servlet, installation, 12-36
syntax guidelines, 12-13
URL specification, 12-13
XPath expressions in, 12-14
DBUri-refs, 12-10
HTTP access, 12-34
where it can be used, 12-18
DBUriType
defined, 12-2
examples, 12-25
notation for fragments, 12-13
stores references to data, 12-6
default table
creating, 5-70
defining a, 3-40
defaultTable attribute, 5-70
deleting
resources, 3-39, 15-13
rows using extract(), 4-38
rows with XMLType columns, 4-38
using extract(), 4-38
XML schema using DBMS_XMLSCHEMA, 5-13
DEPTH, 15-11
dequeuing
with AQ XML servlet, 24-13
document
fidelity, explained, 1-4
no order, 5-64
no order with extract(), 5-68
order, 5-62
order with extract(), 5-67
order, query rewrites with collection, 5-60
ordering preserved in mapping, 5-68
DOM
differences, and SAX, 8-6
explained, 1-27
fidelity, 5-21
fidelity, default, 5-56
fidelity, in structured storage, 4-5
fidelity, structured or unstructured storage, 3-27
fidelity, summarized, 1-4
fidelity, SYS_XDBPD$, 5-21
introduced, 8-5
Java API, 9-2
Java API features, 9-15
Java API, XMLType classes, 9-17
NodeList, 8-22
non-supported, 8-5
DOM API for PL/SQL, 8-5
DOMDocument, 9-18
dropping
XMLType columns, 4-9
DTD
limitations, B-33

E

elementFormDefault, 5-61
elements
access control entries (ACEs), 18-6
any, 13-6
complexType, B-3
Contents, Resource index, 13-6
simpleType, B-3
XDBBinary, 13-11
XML, 8-4
enqueuing
adding new recipients after, 24-15
using AQ XML servlet, 24-10
EQUALS_PATH
summary, 15-6
syntax, 15-9
existsNode
and CONTAINS, querying, 7-38
dequeing messages, 2-10
finding XML elements, nodes, 4-20
indexing with CTXXPATH, 7-45
query rewrite, 5-51
XPath rewrites, 5-62
exporting XML table, 23-3
extract, 5-67
deleting, 4-38
dequeing messages, 2-10
mapping, 5-68
query rewrite, 5-51
querying XMLType, 4-26
rewrite in XPath expressions, 5-67
extracting
data from XML, 4-27
extractValue, 4-24
creating indexes, query rewrite, 5-66
query rewrite, 5-51
rewrites in XPath expressions, 5-65

F

factory method, 12-26
folder, defined, 13-4
foldering
explained, 13-2
summary, 1-11
FORCE mode option, 5-14
Frequently Asked Questions (FAQs)
AQ and XML, 24-14
Oracle Text, 7-65
versioning, 14-12
FTP
configuration parameters, Oracle XMl DB, 19-5
creating default tables, 5-70
protocol server, features, 19-7
protocol server, using, 3-45
function-based index
creating in Enterprise Manager, 21-42
creating on extract or existsNode, 4-39
functions
createXML, 4-15
DBUriType, 12-19
isSchemaValid, 6-10
isSchemaValidated, 6-9
schemaValidate, 6-9
setSchemaValidated, 6-10
SYS_DBURIGEN, 12-29
SYS_XMLAgg, 10-51
SYS_XMLGEN, 10-42
transform, 6-2
updateXML, 5-69
XMLAgg, 10-17
XMLColAttVal, 10-20
XMLConcat, 10-15
XMLElement, 10-5
XMLForest, 10-9
XMLSequence, 10-11, 10-13
XMLTransform, 6-2
XMLType, 4-7

G

generating
DBUriType using SYS_DBURIGEN, 12-29
generating XML
DBMS_XMLGEN example, 10-30
element forest
XMLColAttVal, 10-20
from SQL, DBMS_XMLGEN, 10-21
one document from another, 10-12
SQL, SYS_XMLGEN, 10-42
SYS_XMLAgg, 10-51
using SQL functions, 10-2
XML SQL Utility (XSU), 10-54
XMLAgg, 10-17
XMLConcat, 10-15
XMLElement, 10-5
XMLForest, 10-9
XMLSequence, 10-11
XSQL, 10-52
getClobVal
summarized, 3-18
getNameSpace
summarized, 3-18
getRootElement
summarized, 3-18
getXMLType, 9-17
global XML schema, 5-12
groups, 18-6

H

HASPATH, 4-40, 7-10
operator, 7-12
path existence searching, 7-20
path searching, 7-19
highlighting
XML documents with Oracle Text, 7-49
HTTP
access for DBUri-refs, 12-34
accessing Java servlet or XMLType, 20-3
accessing Repository resources, 13-11
configuration parameters, WebDAV, 19-5
creating default tables, 5-70
HttpUriType, DBUriType, 12-23
improved performance, 19-2
Oracle XML DB servlets, 20-8
protocol server, features, 19-9
requests, 20-8
servlets, 20-4
UriFactory, 12-38
using UriRefs to store pointers, 12-7
HttpUriType
accesses remote pages, 12-6
defined, 12-2
hub-and-spoke architecture, enabled by AQ, 24-4

I

IDAP
architecture, 24-7
transmitted over Internet, 24-7
XML schema, 24-14
IMPORT/EXPORT
in XML DB, 23-2
index
collection, 5-60
Index Organized Table (IOT), 5-71
indexing
B*Tree, 3-26
function-based on existsNode(), 4-39
in structured, unstructured storage, 3-26
Oracle Text, CTXXPATH, 7-45
Oracle Text, XMLType, 7-35
XMLType, 4-39
Information Set
W3C introducing XML, C-26
inheritance
in XML schema, restrictions in complexTypes, 5-43
INPATH, 4-40, 7-10
operator, 7-13
INPATH operator, 7-12
inserting
into XMLType, 4-9
new instances, 5-51
XML data into XMLType columns, 4-15
installing
from scratch, Oracle XML DB, A-2
manually without DBCA, A-4
instance document
specifying root element namespace, 5-5
XML, described, B-36
Internet Data Access Presentation (IDAP)
SOAP specification for AQ, 24-7
isFragment
summarized, 3-18
isSchemaValid, 6-10
isSchemaValidated, 6-9

J

Java
Oracle XML DB guidelines, 20-3
using JDBC to access XMLType objects, 20-3
writing Oracle XML DB applications, 20-2
Java DOM API for XMLType, E-2
JDBC
accessing documents, 9-3
manipulating data, 9-5
using SQL to determine object properties, 17-3
JNDI, 9-2
using Resource API, 17-2

L

lazy manifestation, 8-4
Lazy Manifestation (LM), 3-26
LDAP
Oracle XML DB, in, 18-5
Least Recently Used (LRU), 3-26
Link, 16-2
LOBs
mapping XML fragments to, 5-39
location path, C-5
LockResource, 16-2

M

maintainDOM, 5-64
maintainOrder attribute, 5-37
mapping
collection predicates, 5-59
complexType any, 5-45
complexTypes to SQL, 5-37
overriding using SQLType attribute, 5-32
predicates, 5-58
scalar nodes, 5-58
simpleContent to object types, 5-44
simpleType XML string to VARCHAR2, 5-36
simpleTypes, 5-33
type, setting element, 5-31
maxOccurs, 5-37
MIME
overriding with DBUri servlet, 12-35
modes
CASCADE, 5-14
FORCE, 5-14
MULTISET operator
using with SYS_XMLGEN selects, 10-47

N

NamedNodeMap object, 8-22
namespace
defining, 3-29
handling in query rewrites, 5-61
handling in XPath, 5-61
W3C introducing, C-18
XDBResource, 13-17
XML schema URL, 5-5
xmlns, D-4
XMLSchema-Instance, 3-21
naming SQL objects
SQLName, SQLType attributes, 5-24
navigational access, 13-9
nested
generating nested XML using DBMS_XMLGEN, 10-32
object tables, 3-32
sections in Oracle Text, 7-55
XML, generating with XMLElement, 10-7
XMLAgg functions and XSQL, 10-52
newDOMDocument, 8-22
NodeList object, 8-22
NULL
mapping to in XPath, 5-60

O

object references and DBUri, 12-18
operators
CONTAINS, 4-39, 7-6
CONTAINS compared, 4-42
DEPTH, 15-11
EQUALS_PATH, 15-9
HASPATH, 7-12
INPATH, 7-12, 7-13
MULTISET and SYS_XMLGEN, 10-47
PATH, 15-9
UNDER_PATH, 15-7
WITHIN, 7-8, 7-11
XMLIsValid, 6-9
Oracle Enterprise Manager
configuring Oracle XML DB, 21-7
console, 21-7
creating a view based on XML schema, 21-39
creating function-based index, 21-42
creating resources, 21-12
features, 21-3
granting privileges, XML Tab, 21-23
managing security, 21-22
managing XML schema, 21-27
Oracle Net Services, 1-11
Oracle Text
advanced techniques, 7-45, 7-49
ALTER INDEX, 7-10
attribute sections, constraints, 7-54
building query applications, 7-21
comparing CONTAINS and existsNode, 7-38
conference Proceedings example, 7-57
CONTAINS and XMLType, 4-39
CONTAINS operator, 7-6
creating index on XMLType columns, 4-12
creating on XMLType columns, 4-40
CTXSYS, 7-5
CTXXPATH, 7-45
DBMS_XDBT, F-27
installing, 7-4
Oracle XML DB, and, 7-37
querying, 7-6
querying within attribute sections, 7-30
searching data with, 7-3
searching XML in CLOBs, 1-23
section_group, deciding which to use, 7-23
users and roles, 7-5
XMLType, 7-4
XMLType indexing, 7-35
Oracle XML DB, 3-5
access models, 2-7
advanced queueing, 1-23
application language, 2-8
architecture, 1-7
benefits, 1-3
configuring with Enterprise Manager, 21-7
designing, 2-3
features, 1-4
foldering, 13-2
installation, A-2
installing, 2-2
installing manually, A-4
introducing, 1-2
Java applications, 20-2
processing models, 2-9
Repository, 1-6, 3-35, 13-4
storage models, 2-10
storing XMLType, 4-4
upgrading, A-5
using XSL/XSLT with, 3-16
versioning, 14-2
when to use, 2-2
Oracle XML DB Resource API for Java/JNDI
examples, 17-3
using, 17-2
oracle.xdb, E-2
oracle.xdb.dom, E-2
oracle.xdb.spi, E-6
XDBResource.getContent(), E-9
XDBResource.getContentType, E-9
XDBResource.getCreateDate, E-9
XDBResource.getDisplayName, E-9
XDBResource.getLanguage(), E-9
XDBResource.getLastModDate, E-9
XDBResource.getOwnerId, E-9
XDBResource.setACL, E-9
XDBResource.setAuthor, E-9
XDBResource.setComment, E-9
XDBResource.setContent, E-9
XDBResource.setContentType, E-10
XDBResource.setCreateDate, E-10
XDBResource.setDisplayName, E-10
XDBResource.setInheritedACL, E-10
XDBResource.setLanguage, E-10
XDBResource.setLastModDate, E-10
XDBResource.setOwnerId, E-10
oracle.xdb.XMLType, 9-17
ora.contains
creating a policy for, 7-42
XPath full-text searches, 7-40
ordered collections in tables (OCTs), 5-71
default storage of VARRAY, 5-37
rewriting collection index, 5-60

P

PATH, 15-9
PATH_SECTION_GROUP
using, 7-10
PATH_VIEW, 3-38
structure, 15-4
Path-based access
explained, 13-9
pathname
resolution, 13-7
performance
improved using Java writeToStream, 13-12
improvement for structured storage, 3-25
piecewise update, 1-5
PL/SQL DOM
examples, 8-24
methods, 8-11
PL/SQL Parser for XMLType, F-14
PL/SQL XSLT Processor for XMLType, F-15
point-to-point
support in AQ, 24-2
Positional Descriptor (PD), 5-21
predicates, 5-58
collection, mapping of, 5-59
principals, 18-6
privileges
aggregate, 18-9
atomic, 18-8
granting from Oracle Enterprise Manager, 21-23
processXSL, 8-33
protocol server
architecture, 19-3
configuration parameters, 19-4
event-based logging, 19-7
FTP, 19-7
FTP configuration parameters, 19-5
HTTP, 19-9
HTTP/WebDAV configuration parameters, 19-5
Oracle XML DB, 19-2
using, 3-44
WebDAV, 19-11
protocols
access calling sequence, 13-11
access to Repository resources, 13-10
retrieving resource data, 13-11
storing resource data, 13-11
publish/subscribe
support in AQ, 24-2
purchase order
XML, 3-6
purchaseorder.xsl, D-6

Q

query access
using RESOURCE_VIEW and PATH_VIEW, 15-2
query results
presenting, 7-21, 7-34
query rewrite, 5-51
query-based access
using SQL, 13-12
querying
resources, 3-38
XML data, 4-17
XMLType, 4-18
XMLType,transient data, 4-27

R

rebuilding hierarchical indexes, 16-11
REF attribute, 5-38, 5-47
registerHandler, 12-27
Reinstalling
Oracle XML DB
reinstalling, A-4
Repository, 3-35, 13-4
based on WebDAV, 3-35
hierarchy explained, 3-35
query-based access, 3-37
where is the data stored, 13-6
resource id
new version, 14-5
RESOURCE_VIEW
explained, 15-2
PATH_VIEW differences, 15-5
querying resource documents, 3-38
structure, 15-3
resources
access using UNDER_PATH, 15-11
accessing Repository, 13-8
accessing with protocols, 19-6
changing privileges, 18-13
configuration management, 16-8
controlling access to, 18-7
creating from Enterprise Manager, 21-12
defined, 13-4
deleting, 13-7
deleting non-empty containers, 15-13
deleting using DELETE, 15-13
extending metadata properties, 13-17
inserting data using RESOURCE_VIEW, 15-11
management using DBMS_XDB, 16-2
managing, 18-12
multiple simultaneous operations, 15-15
required privileges for operations, 18-9
retrieving access control lists (ACLs), 18-13
setting property in access control lists (ACLs), 18-12
storage options, 3-40
updating, 15-14
ResourceType
extending, 13-17

S

scalar nodes, mapping, 5-58
scalar value
converting to XML document using SYS_XMLGEN, 10-46
schemaLocation, 5-10
schemaValidate, 3-24, 6-9
method, 5-15
searching CLOBs, 1-23
security
access control entries (ACEs), 18-6
aggregate privileges, 18-9
DBUri, 12-37
management using DBMS_XDB, 16-5
management with Enterprise Manager, 21-22
user and group access, 18-6
servlets
accessing Repository data, 13-13
and session pooling, 20-9
APIs, 20-10
AQ XML, 24-13
configuring, 20-12
configuring Oracle XML DB, 20-4
DBUri, URL into a query, 12-34
example, 20-10
explained, 1-29
installing, 20-11
session pooling, 20-9
session pooling and Oracle XML DB, 19-2
testing the, 20-12
writing Oracle XML DB HTTP, 20-4
XML manipulation, with, 20-3
session pooling, 20-9
protocol server, 19-2
setSchemaValidated, 6-10
Simple Object Access Protocol (SOAP) and IDAP, 24-7
simpleContent
mapping to object types, 5-44
simpleType
elements, B-3
mapping to SQL, 5-33
mapping to VARCHAR2, 5-36
SOAP
access through Advanced Queueing, 1-11
and IDAP, 24-7
space
requirements in structured, unstructured storage, 3-27
SQL functions
existsNode, 4-20
extractValue, 4-24
SQL*Loader, 22-2
SQLInLine attribute, 5-37
SQLName, 5-24
SQLType, 5-24, 5-28
attribute, 5-39
SQLX
generating XML, 10-5
generating XML, for, 10-2
operators, explained, 1-5
Oracle extensions, 10-2
storage
of complex types, 3-32
options for resources, 3-40
structured, 3-33
XMLDATA, 4-13
structured or unstructured, 3-24
structured, query rewrite, 5-51
VARRAYs and OCT, 5-71
XML-schema-based, 5-20
XMLType CREATE TABLE, 5-50
storeVarrayAsTable attribute, 5-71
substitution
creating columns by inserting HttpUriType, 12-25
/sys, restrictions, 13-3
SYS_DBURIGEN, 12-29
examples, 12-31
inserting database references, 12-31
passing columns or attributes, 12-30
retrieving object URLs, 12-33
returning partial results, 12-32
returning Uri-refs, 12-33
text function, 12-31
SYS_REFCURSOR
generating a document for each row, 10-13
SYS_XDBPD$, 5-21, 5-64
in query rewrites, 5-57
suppressing, 5-22
SYS_XMLAgg, 10-51
SYS_XMLGEN, 10-42
converting a UDT to XML, 10-47
converting XMLType instances, 10-48
generating XML in SQL queries, 4-12
inserting, 4-17
object views, 10-49
static member function create, 10-45
using with object views, 10-49
XMLFormat attributes, 10-44
XMLGenFormatType object, 10-44

T

tableProps attribute, 5-70
tablespace
do not drop, A-2
transform, 6-2
triggers
BEFORE INSERT trigger, 3-24
BEFORE INSERT, using with XMLType, 3-23
creating XMLType, 4-38
using with XMLType, 4-38

U

UDT
generating an element from, 10-9
generating an element using XMLForest, 10-10
UNDER_PATH, 3-38, 15-7
summary, 15-6
updateXML, 5-69
creating views, 4-35
mapping NULL values, 4-36
replacing contents of node tree, 3-14
updating text node value, 3-13
updating
resources, 3-38, 15-14
same node more than once, 4-37
upgrading
existing installation, A-5
URI
base, C-28
UriFactory, 12-26
configuring to handle DBUri-ref, 12-38
factory method, 12-26
generating UriType instances, 12-26
registering ecom protocol, 12-27
registering new UriType subtypes, 12-26
registerURLHandler, 12-27
Uri-ref, see also Uri-reference, 12-4
Uri-reference
database and session, 12-18
datatypes, 12-6
DBUri, 12-10
DBUri and object references, 12-18
DBUri syntax guidelines, 12-13
DBUri-ref, 12-10
DBUri-ref uses, 12-18
DBUriType examples, 12-25
explained, 12-4
HTTP access for DBUri-ref, 12-34
UriFactory package, 12-26
UriType examples, 12-24
UriTypes, 12-23
UriTypes, 12-23
benefits, 12-7
creating Oracle Text index on column, 7-37
examples, 12-24
subtypes, advantages, 12-29
URL
identifying XML schema, for, 5-5

V

validating
examples, 6-10
isSchemaValid, 6-10
isSchemaValidated, 6-9
schemaValidate, 6-9
SetSchemaValidated, 6-10
with XML schema, 5-7
VARRAYS
inline, 3-32
storage using OCT, 5-71
VCR, 14-4, 14-6
access control and security, 14-8
version-controlled resource (VCR), 14-4, 14-6
versioning, 1-10, 14-2
FAQs, 14-12
views
RESOURCE and PATH, 15-2

W

W3C DOM Recommendation, 8-9
WebDAV
protocol server, features, 19-11
standard introduced, 3-35
WebFolder
creating in Windows 2000, 19-12
WITHIN
in Oracle Text, 7-8
limitations, 7-11
syntax, 7-11
writeToStream, 13-12

X

XDB$RESOURCE table, 13-18
XDBBinary, 13-5, 13-11
explained, 1-28
xdbconfig.xml, 19-2
XDBResource
namespace, 13-17
xsd, 13-17
XDBSchema.xsd, 5-19
XDBUri, 12-5
XDBUriType
accessing non-schema content, 3-44
accessing Repository content, 3-44
defined, 12-2
stores references to Repository, 12-6
XDK for PL/SQL, backward compatibility, 8-2
XML
binary datatypes, 5-34
fragments, mapping to LOBs, 5-39
primitive datatypes, 5-36
primitive numeric types, 5-34
XML DB Resource API for Java/JNDI, 17-2
XML DB, Oracle, 3-5
XML schema
and Oracle XML DB, 1-7, 5-5
benefits, 5-6
compared to DTD, B-31
complexType declarations, 5-41
creating default tables during registration, 5-70
cyclical references, 5-74
cyclical references between, 5-71
DTD limitations, B-33
elementFormDefault, 5-61
Enterprise Manager, managing them from, 21-27
features, B-34
global, 5-12
inheritance in, complexType restrictions, 5-43
key feature explained, 1-5
local, 5-11
local and global, 5-11
managing and storing, 5-19
mapping to SQL object types, 8-10
navigating in Enterprise Manager, 21-28
registering, 5-8
registering using DBMS_XMLSCHEMA, 5-9
root, 5-19
SQL mapping, 5-28
storage and access, 5-13
storage of XMLType, 3-28
unsupported constructs in query rewrites, 5-54
updateXML(), 5-69
URLs, 5-16
validating an XML document, 3-22
W3C Recommendation, 3-18, 5-3
xdb.SQLType, 3-31
XMLType methods, 5-19
XML schema, creating a view in Enterprise Manager, 21-39
XML Schema, introducing W3C, B-2
XML SQL Utility
generating XML, 10-54
XML SQL Utility (XSU)
generating XML, 10-3
XML storage, 3-24
XML_SECTION_GROUP
using, 7-8
XMLAgg, 10-17
XMLAttributes, 10-7
XMLColAttVal, 10-20
XMLConcat, 10-15
concatenating XML elements in argument, 10-16
returning XML elements by concatenating, 10-16
XMLDATA
column, 5-58
optimizing updates, 5-69
parameter, F-3
pseudo-attribute of XMLType, 5-50
structured storage, 4-13
XMLElement, 10-5
attribute, 10-7
generating elements from DTD, 10-9
using namespaces to create XML document, 10-8
XMLForest, 10-9
generating elements, 10-10
generating elements from DTD, 10-10
XMLFormat
XMLAgg, 10-17
XMLFormat object type
SYS_XMLGEN
XMLFormatType object, 10-44
XMLGenFormatType object, 10-44
XMLIsValid
validating
XMLIsValid, 6-9
XMLSequence, 10-11
extracting description nodes, 3-12
generating an XML document for each row, 10-13
generating one document from another, 10-12
unnesting collections in XML to SQL, 10-14
XMLTransform, 4-37, 6-2
XMLType, 4-2
adding columns, 4-8
API, F-2
benefits, 4-3
CLOB storage, 4-5
column, 3-3
constraints, specifying, 4-14
CONTAINS operator, 4-39
CREATE TABLE, 5-50
creating columns, 4-8
creating columns, example, 4-8
creating Oracle Text index, 4-12
deleting a row containing, 4-10
deleting rows, 4-38
deleting using extract(), 4-38
dropping columns, 4-9
extracting data, 4-27
functions, 4-7
guidelines for using, 4-11
how to use, 4-7
indexing, 7-35
indexing columns, 4-39
inserting into, 4-9
inserting with createXML() using string, 4-16
inserting with SYS_XMLGEN(), 4-17
inserting XML data, 4-15
instances, PL/SQL APIs, 8-2
Java
writeToStream, 13-12
loading data, 22-2
manipulating data in columns, 4-14
Oracle Text support, 7-4
querying, 4-17, 4-18
querying transient data, 4-27
querying with extract() and existsNode(), 4-26
querying XMLType columns, 4-27
queue payloads, 24-8
storage architecture, 1-11
storage characteristics, 4-12
storing data in Oracle XML DB, 4-4
summarized, 1-4
table, 3-3
table storage, 1-9
table, querying with JDBC, 9-3
tables, storing, 5-23
tables, views, columns, 5-15
triggers, 4-38
updating column, example, 4-10
using in SQL SELECT statement, 4-9
views,access with PL/SQL DOM APIs, 8-11
when to use, 4-4
Xpath support, 4-39
XMLType, loading with SQL*Loader, 22-2
XPath
basics, D-5
explained, 1-27
expressions, mapping, 5-57
mapping for extract(), 5-67
mapping for extract() without document order, 5-68
mapping for extractValue(), 5-65
mapping to NULL in, 5-60
mapping, simple, 5-57
rewrites for existNode(), 5-62
rewriting expressions, 5-53
support, 4-39
text(), 5-58
unsupported constructs in query rewrites, 5-54
use for searching data, 1-5
using with Oracle XML DB, 3-5
W3C introducing, C-2
XPath expressions
supported, 5-54
xsi.noNamespaceSchemaLocation, 5-5
XSL
and CSS, D-5
basics, D-2
defined, 1-27
XSL stylesheet, example, D-6
XSLT, 8-11
1.1 specification, D-5
explained, D-5
xsql
include-xml
aggregating results into one XML, 10-52
generating XML from database, 10-53
XSQL Pages Publishing Framework
generating XML, 10-3, 10-52