Oracle9i XML Database Developer's Guide

access control entries (ACEs), 18-9

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-11

managing from Enterprise Manager, 21-22

restrictions, 18-12

security, row-level, 18-13

setting the resource property, 18-11

summary, 1-12

term explained, 1-30

updating, 18-10

using, 18-9

accessing

Java examples for, 9-4

using XDBUriType, 3-44

with JDBC, 9-4

XML documents using Java, 9-3

adding

XMLType columns, 4-8

Advanced Queuing (AQ)

definition, 23-2

enqueuing, 23-9

hub-and-spoke architecture support, 23-4

IDAP, 23-5

message management support, 23-4

messaging scenarios, 23-2

point-to-point support, 23-2

publish/subscribe support, 23-2

XML servlet, 23-11

XMLType queue payloads, 23-6

aggregating

XSQL and XMLAgg, 10-51

ALTER INDEX, using sections, 7-10

any, 13-6

attributes

collection, 5-38

columnProps, 5-71

Container, 13-7

defaultTable, 5-71

for root element, 3-21

in elements, 5-26

maintainDOM, 5-22

maintainOrder, 5-38

mapping any, 5-46

maxOccurs, 5-38

namespaces, 5-5

noNameSpaceSchemaLocation, 3-21

of XMLFormat, 10-44

passing to SYS_DBURIGEN, 12-30

REF, 5-39, 5-48

schemaLocation, 3-21, 5-9

setting to NULL, 4-35

SQLInLine, 5-38, 5-39

SQLName, 5-25

SQLSchema, 5-25

SQLType, 5-25, 5-29, 5-40

storeVarrayAsTable, 5-72

SYS_XDBPD$, 5-58

tableProps, 5-71

xdb.defaultTable, 3-40

xdb.SQLType, 3-30

XMLAttributes in XMLElement, 10-7

XMLDATA, 4-13, 5-51

XMLType, in AQ, 23-6

xsi.NamespaceSchemaLocation, 5-5

xsi.noNamespaceSchemaLocation, 11-10

authenticatedUser

DBuri security, 12-37

AUTO_SECTION_GROUP

using, 7-10

B*Tree, 1-12, 4-6, 5-52

indexing, 3-26

bootstrap ACL, 18-4

CASCADE mode, 5-13

cascading style sheets, see CSS, D-7

catalog views, F-18

cfg_get, 16-9, A-9

cfg_refresh, A-10

CharacterData, 8-21

Classes

XDBContextFactory

initial contexts for JNDI, 17-6

CLOB storage of XMLType, 4-5

collection attribute, 5-38

collection index, 5-61

collections, 3-32, 18-6

columnProps attribute, 5-71

complexType

collections, 3-32

cycling, 5-49

cycling between, 5-47

elements, B-3

handling inheritance, 5-42

in XML schema, explained, B-35

mapping any and any attributes, 5-46

mapping to SQL, 5-38

restrictions, 5-42

concatenating

elements using XMLConcat, 10-16

configuring

API, A-9

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-52

structured storage, 3-33

using with XMLType tables, 3-22

CONTAINS, 4-38, 7-6

compared against existsNode, 7-38

compared to existsNode(),extract(), 4-41

contents, element, 13-6

CREATE TABLE

XMLType storage, 5-51

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-23

XMLType columns, 4-8

XMLType table, 4-7

CSS and XSL, D-7

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-49

data integrity

in structured, unstructured storage, 3-26

Oracle XML DB, 3-33

date

format conversion in updateXML(), 5-71

format conversions for XML, 5-63

mapping to SQL, 5-36

DBMS_METADATA, 12-5

DBMS_XDB, F-19

AclCheckPrivileges, database objects, 18-13

cfg_get, A-9

cfg_refresh, A-10

changePrivilege, 18-12

checkPrivileges, 18-13

configuration management, 16-8

getAclDocument, 18-12

Link, 16-2

LockResource, 16-2

overview, 16-2

rebuilding hierarchical index, 16-11

security, 16-5

DBMS_XDB_VERSION, 14-2, F-24

subprograms, 14-9

DBMS_XDBT, F-25

DBMS_XMLDOM, 8-5, 8-12, F-6

DBMS_XMLGEN, 10-20, F-22

generating complex XML, 10-29

generating XML, 10-2

DBMS_XMLPARSER, 8-24, F-13

DBMS_XMLSCHEMA, 5-7, F-15

deleteSchema, 5-7

generateSchema() function, 5-18

generateSchemas() function, 5-18

mapping of types, 5-32

registerSchema, 5-7

DBMS_XSLPROCESSOR, 8-28, F-14

dbmsxsch.sql, F-15

DBUri, 12-10

and object references, 12-17

identifying a row, 12-15

identifying a target column, 12-16

retrieving column text value, 12-16

retrieving the whole table, 12-14

security, 12-37

servlet, 12-34

servlet, installation, 12-36

syntax guidelines, 12-13

URL specification, 12-12

XPath expressions in, 12-13

DBUri-refs, 12-9

HTTP access, 12-34

where it can be used, 12-17

DBUriType

defined, 12-2

examples, 12-25

notation for fragments, 12-12

stores references to data, 12-6

default table

creating, 5-71

defining a, 3-40

defaultTable attribute, 5-71

deleteSchema, 9-21

deleting

resources, 3-39, 15-10

rows using extract(), 4-37

rows with XMLType columns, 4-37

using extract(), 4-37

XML schema using DBMS_XMLSCHEMA, 5-13

DEPTH, 15-8

dequeuing

with AQ XML servlet, 23-11

document

fidelity, explained, 1-4

no order, 5-65

no order with extract(), 5-69

order, 5-63

order with extract(), 5-68

order, query rewrites with collection, 5-61

ordering preserved in mapping, 5-69

DOM

differences, and SAX, 8-6

explained, 1-28

fidelity, 5-21

fidelity, default, 5-57

fidelity, in structured storage, 4-5

fidelity, structured or unstructured storage, 3-27

fidelity, summarized, 1-4

fidelity, SYS_XDBPD$, 5-22

introduced, 8-5

Java API, 9-2

Java API features, 9-16

Java API, XMLType classes, 9-18

NodeList, 8-21

non-supported, 8-5

DOM API for PL/SQL, 8-5

DOMDocument, 9-19

dropping

XMLType columns, 4-8

DTD

limitations, B-33

elementFormDefault, 5-62

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, 23-14

using AQ XML servlet, 23-9

EQUALS_PATH

summary, 15-5

syntax, 15-8

existsNode

and CONTAINS, querying, 7-38

dequeing messages, 2-10

finding XML elements, nodes, 4-20

indexing with CTXXPATH, 7-45

query rewrite, 5-52

XPath rewrites, 5-63

extract, 5-68

deleting, 4-37

dequeing messages, 2-10

mapping, 5-69

query rewrite, 5-52

querying XMLType, 4-26

rewrite in XPath expressions, 5-68

extracting

data from XML, 4-27

extractValue, 4-23

creating indexes, query rewrite, 5-67

query rewrite, 5-52

rewrites in XPath expressions, 5-66

factory method, 12-25

folder, defined, 13-4

foldering

explained, 13-2

summary, 1-12

FORCE mode option, 5-13

Frequently Asked Questions (FAQs)

AQ and XML, 23-13

Oracle Text, 7-64

versioning, 14-12

FTP

configuration parameters, Oracle XMl DB, 19-5

creating default tables, 5-71

protocol server, features, 19-7

protocol server, using, 3-44

function-based index

creating in Enterprise Manager, 21-42

creating on extract or existsNode, 4-38

functions

createXML, 4-15

DBUriType, 12-18

isSchemaValid, 6-10

isSchemaValidated, 6-9

schemaValidate, 6-9

setSchemaValidated, 6-10

SYS_DBURIGEN, 12-29

SYS_XMLAgg, 10-50

SYS_XMLGEN, 10-41

transform, 6-2

updateXML, 5-70

XMLAgg, 10-17

XMLColAttVal, 10-19

XMLConcat, 10-15

XMLElement, 10-5

XMLForest, 10-9

XMLSequence, 10-11, 10-13

XMLTransform, 6-2

XMLType, 4-7

genbean flag, 9-21

generating

DBUriType using SYS_DBURIGEN, 12-29

generating XML

DBMS_XMLGEN example, 10-29

element forest

XMLColAttVal, 10-19

from SQL, DBMS_XMLGEN, 10-20

one document from another, 10-12

SQL, SYS_XMLGEN, 10-41

SYS_XMLAgg, 10-50

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-51

getClobVal

summarized, 3-17

getNameSpace

summarized, 3-17

getRootElement

summarized, 3-17

getXMLType, 9-18

global XML schema, 5-11

groups, 18-6

HASPATH, 4-39, 7-10

operator, 7-12

path existence searching, 7-20

path searching, 7-19

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-71

HttpUriType, DBUriType, 12-23

improved performance, 19-2

Oracle XML DB servlets, 20-8

protocol server, features, 19-8

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, 23-4

IDAP

architecture, 23-6

transmitted over Internet, 23-5

XML schema, 23-12

index

collection, 5-61

Index Organized Table (IOT), 5-72

indexing

B*Tree, 3-26

function-based on existsNode(), 4-38

in structured, unstructured storage, 3-26

Oracle Text, CTXXPATH, 7-45

Oracle Text, XMLType, 7-34

XMLType, 4-38

Information Set

W3C introducing XML, C-26

inheritance

in XML schema, restrictions in complexTypes, 5-44

INPATH, 4-39, 7-10

operator, 7-12

INPATH operator, 7-12

inserting

into XMLType, 4-9

new instances, 5-52

XML data into XMLType columns, 4-15

installing

from scratch, Oracle XML DB, A-2

manually without DBCA, A-3

instance document

specifying root element namespace, 5-5

XML, described, B-36

Internet Data Access Presentation (IDAP)

SOAP specification for AQ, 23-5

isFragment

summarized, 3-17

isSchemaValid, 6-10

isSchemaValidated, 6-9

Java

Oracle XML DB guidelines, 20-3

using JDBC to access XMLType objects, 20-3

writing Oracle XML DB applications, 20-2

Java bean

deleteSchema, 9-21

genbean flag, 9-21

generated example, 9-24

generated names, 9-21

generated with XML schema registration, 5-17

only for XML schema-based, 5-18

Java Bean API for XMLType, 9-20, E-6

using, 9-21

Java DOM API for XMLType, E-2

Java Stored Procedure, 9-26

JDBC

accessing documents, 9-4

manipulating data, 9-6

using SQL to determine object properties, 17-13

JNDI, 9-3, E-7

bind(), 9-17

context inputs, 17-8

context outputs, 17-10

determining properties, 17-11

oracle.xdb.spi, 17-3

support, 17-2

using Resource API, 17-4

Lazy Manifestation (LM), 3-25

LDAP

Oracle XML DB, in, 18-5

Least Recently Used (LRU), 3-25

Link, 16-2

LOBs

mapping XML fragments to, 5-40

location path, C-5

LockResource, 16-2

maintainDOM, 5-65

maintainOrder attribute, 5-38

mapping

collection predicates, 5-60

complexType any, 5-46

complexTypes to SQL, 5-38

overriding using SQLType attribute, 5-33

predicates, 5-59

scalar nodes, 5-59

simpleContent to object types, 5-45

simpleType XML string to VARCHAR2, 5-37

simpleTypes, 5-34

SQL to Java, 9-23

type, setting element, 5-32

XML to Java bean, XML schema entities, 9-23

maxOccurs, 5-38

MIME

overriding with DBUri servlet, 12-35

modes

CASCADE, 5-13

FORCE, 5-13

MULTISET operator

using with SYS_XMLGEN selects, 10-46

NamedNodeMap object, 8-21

namespace

defining, 3-28

handling in query rewrites, 5-62

handling in XPath, 5-62

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-25

navigational access, 13-9

nested

generating nested XML using DBMS_XMLGEN, 10-31

object tables, 3-32

sections in Oracle Text, 7-54

XML, generating with XMLElement, 10-7

XMLAgg functions and XSQL, 10-51

newDOMDocument, 8-20

NodeList object, 8-21

NULL

mapping to in XPath, 5-61

object references and DBUri, 12-17

operators

CONTAINS, 4-38, 7-6

CONTAINS compared, 4-41

DEPTH, 15-8

EQUALS_PATH, 15-8

HASPATH, 7-12

INPATH, 7-12

MULTISET and SYS_XMLGEN, 10-46

PATH, 15-8

UNDER_PATH, 15-6

WITHIN, 7-7, 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-12

Oracle Text

advanced techniques, 7-45, 7-49

ALTER INDEX, 7-10

attribute sections, constraints, 7-52

building query applications, 7-21

comparing CONTAINS and existsNode, 7-38

conference Proceedings example, 7-56

CONTAINS and XMLType, 4-38

CONTAINS operator, 7-6

creating index on XMLType columns, 4-11

creating on XMLType columns, 4-39

CTXSYS, 7-5

CTXXPATH, 7-45

DBMS_XDBT, F-25

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-24

section_group, deciding which to use, 7-23

users and roles, 7-5

XMLType, 7-4

XMLType indexing, 7-34

Oracle XML DB, 3-5

access models, 2-7

advanced queueing, 1-24

application language, 2-8

architecture, 1-8

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-3

introducing, 1-2

Java applications, 20-2

processing models, 2-9

Repository, 1-6, 3-34, 13-4

storage models, 2-10

storing XMLType, 4-4

upgrading, A-4

using XSL/XSLT with, 3-16

versioning, 14-2

when to use, 2-2

Oracle XML DB Resource API for Java/JNDI

calling sequence, 17-5

examples, 17-11

using, 17-4

oracle.xdb, E-2

oracle.xdb.bean, 9-21, E-6

oracle.xdb.dom, E-2

oracle.xdb.spi, 17-9, E-7

JNDI and WebDAV, 17-3

XDBResource.getContent(), E-10

XDBResource.getContentType, E-10

XDBResource.getCreateDate, E-10

XDBResource.getDisplayName, E-10

XDBResource.getLanguage(), E-10

XDBResource.getLastModDate, E-10

XDBResource.getOwnerId, E-10

XDBResource.setACL, E-10

XDBResource.setAuthor, E-10

XDBResource.setComment, E-10

XDBResource.setContent, E-10

XDBResource.setContentType, E-11

XDBResource.setCreateDate, E-11

XDBResource.setDisplayName, E-11

XDBResource.setInheritedACL, E-11

XDBResource.setLanguage, E-11

XDBResource.setLastModDate, E-11

XDBResource.setOwnerId, E-11

oracle.xdb.XDBResource

JNDI, 17-7

oracle.xdb.XMLType, 9-18

JNDI, 17-7

ora.contains

creating a policy for, 7-42

XPath full-text searches, 7-40

ordered collections in tables (OCTs), 5-72

default storage of VARRAY, 5-38

rewriting collection index, 5-61

PATH, 15-8

PATH_SECTION_GROUP

using, 7-10

PATH_VIEW, 3-38

structure, 15-3

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-22

methods, 8-12

PL/SQL DOM API for XMLType, F-6

PL/SQL Parser for XMLType, F-13

PL/SQL XSLT Processor for XMLType, F-14

point-to-point

support in AQ, 23-2

Positional Descriptor (PD), 5-22

predicates, 5-59

collection, mapping of, 5-60

principals, 18-6

privileges

aggregate, 18-8

atomic, 18-7

granting from Oracle Enterprise Manager, 21-23

processXSL, 8-31

protocol server

architecture, 19-3

configuration parameters, 19-4

FTP, 19-7

FTP configuration parameters, 19-5

HTTP, 19-8

HTTP/WebDAV configuration parameters, 19-5

Oracle XML DB, 19-2

using, 3-44

WebDAV, 19-10

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, 23-2

purchase order

XML, 3-5

purchaseorder.xsl, D-7

query access

using RESOURCE_VIEW and PATH_VIEW, 15-2

query results

presenting, 7-21, 7-34

query rewrite, 5-52

query-based access

using SQL, 13-12

querying

resources, 3-38

XML data, 4-17

XMLType, 4-18

XMLType,transient data, 4-26

rebuilding hierarchical indexes, 16-11

REF attribute, 5-39, 5-48

registerHandler, 12-26

Reinstalling

Oracle XML DB

reinstalling, A-4

Repository, 3-34, 13-4

based on WebDAV, 3-35

hierarchy explained, 3-35

query-based access, 3-36

where is the data stored, 13-6

resource id

new version, 14-5

RESOURCE_VIEW

explained, 15-2

PATH_VIEW differences, 15-4

querying resource documents, 3-38

structure, 15-3

resources

access using UNDER_PATH, 15-9

accessing Repository, 13-8

accessing with protocols, 19-6

changing privileges, 18-12

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-11

deleting using DELETE, 15-10

extending metadata properties, 13-17

inserting data using RESOURCE_VIEW, 15-9

management using DBMS_XDB, 16-2

managing, 18-11

multiple simultaneous operations, 15-12

required privileges for operations, 18-8

retrieving access control lists (ACLs), 18-12

setting property in access control lists (ACLs), 18-11

storage options, 3-40

updating, 15-11

ResourceType

extending, 13-18

scalar nodes, mapping, 5-59

scalar value

converting to XML document using SYS_XMLGEN, 10-45

schemaLocation, 5-9

schemaValidate, 3-24, 6-9

method, 5-15

searching CLOBs, 1-24

security

access control entries (ACEs), 18-6

aggregate privileges, 18-8

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, 23-11

configuring, 20-12

configuring Oracle XML DB, 20-4

DBUri, URL into a query, 12-34

example, 20-10

explained, 1-30

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, 23-5

simpleContent

mapping to object types, 5-45

simpleType

elements, B-3

mapping to SQL, 5-34

mapping to VARCHAR2, 5-37

SOAP

access through Advanced Queueing, 1-12

and IDAP, 23-5

space

requirements in structured, unstructured storage, 3-26

SQL functions

existsNode, 4-20

extractValue, 4-23

SQL*Loader, 22-2

SQLInLine attribute, 5-38

SQLName, 5-25

SQLType, 5-25, 5-29

attribute, 5-40

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-52

VARRAYs and OCT, 5-72

XML-schema-based, 5-21

XMLType CREATE TABLE, 5-51

storeVarrayAsTable attribute, 5-72

substitution

creating columns by inserting HttpUriType, 12-24

/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-22, 5-65

in query rewrites, 5-58

suppressing, 5-22

SYS_XMLAgg, 10-50

SYS_XMLGEN, 10-41

converting a UDT to XML, 10-46

converting XMLType instances, 10-47

generating XML in SQL queries, 4-12

inserting, 4-16

object views, 10-48

static member function create, 10-44

using with object views, 10-48

XMLFormat attributes, 10-44

XMLGenFormatType object, 10-43

tableProps attribute, 5-71

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-37

using with XMLType, 4-37

UDT

generating an element from, 10-9

generating an element using XMLForest, 10-10

UNDER_PATH, 3-38, 15-6

summary, 15-5

UPDATE_VAL

binding XMLType objects to SQL, 17-2

updateXML, 5-70

creating views, 4-35

mapping NULL values, 4-35

replacing contents of node tree, 3-13

updating text node value, 3-12

updating

resources, 3-38, 15-11

same node more than once, 4-36

upgrading

existing installation, A-4

URI

base, C-28

UriFactory, 12-25

configuring to handle DBUri-ref, 12-38

factory method, 12-25

generating UriType instances, 12-25

registering ecom protocol, 12-27

registering new UriType subtypes, 12-26

registerURLHandler, 12-26

Uri-ref, see also Uri-reference, 12-4

Uri-reference

database and session, 12-17

datatypes, 12-6

DBUri, 12-10

DBUri and object references, 12-17

DBUri syntax guidelines, 12-13

DBUri-ref, 12-9

DBUri-ref uses, 12-17

DBUriType examples, 12-25

explained, 12-4

HTTP access for DBUri-ref, 12-34

UriFactory package, 12-25

UriType examples, 12-23

UriTypes, 12-22

benefits, 12-6

creating Oracle Text index on column, 7-37

examples, 12-23

subtypes, advantages, 12-28

URL

identifying XML schema, for, 5-5

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-72

VCR, 14-4, 14-6

access control and security, 14-8

version-controlled resource (VCR), 14-4, 14-6

versioning, 1-11, 14-2

FAQs, 14-12

views

RESOURCE and PATH, 15-2

W3C DOM Recommendation, 8-9

WebDAV

oracle.xdb.spi, 17-3

protocol server, features, 19-10

standard introduced, 3-35

WebFolder

creating in Windows 2000, 19-11

WITHIN

in Oracle Text, 7-7

limitations, 7-11

syntax, 7-11

writeToStream, 13-12

XDB$RESOURCE table, 13-18

XDBBinary, 13-5, 13-11

explained, 1-29

xdbconfig.xml, 19-2

XDBResource

JNDI Context output, 17-10

namespace, 13-17

xsd, 13-17

XDBSchema.xsd, 5-20

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-35

fragments, mapping to LOBs, 5-40

primitive datatypes, 5-37

primitive numeric types, 5-35

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-42

creating default tables during registration, 5-71

cyclical references, 5-75

cyclical references between, 5-72

DTD limitations, B-33

elementFormDefault, 5-62

Enterprise Manager, managing them from, 21-27

features, B-34

generating Java beans, 5-17

global, 5-11

inheritance in, complexType restrictions, 5-44

key feature explained, 1-5

local, 5-10

local and global, 5-10

managing and storing, 5-20

mapping to SQL object types, 8-10

navigating in Enterprise Manager, 21-28

registering, 5-8

registering using DBMS_XMLSCHEMA, 5-8

root, 5-20

SQL and Java datatypes, 9-23

SQL mapping, 5-29

storage and access, 5-12

storage of XMLType, 3-28

unsupported constructs in query rewrites, 5-55

updateXML(), 5-70

URLs, 5-16

validating an XML document, 3-22

W3C Recommendation, 3-17, 5-3

xdb.SQLType, 3-30

XMLType methods, 5-20

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-19

XMLConcat, 10-15

concatenating XML elements in argument, 10-16

returning XML elements by concatenating, 10-16

XMLDATA

column, 5-59

optimizing updates, 5-70

parameter, F-3

pseudo-attribute of XMLType, 5-51

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-43

XMLGenFormatType object, 10-43

XMLIsValid

validating

XMLIsValid, 6-9

XMLSequence, 10-11

extracting description nodes, 3-11

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-36, 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-38

CREATE TABLE, 5-51

creating columns, 4-8

creating columns, example, 4-8

creating Oracle Text index, 4-11

deleting a row containing, 4-10

deleting rows, 4-37

deleting using extract(), 4-37

dropping columns, 4-8

extracting data, 4-27

functions, 4-7

guidelines for using, 4-11

how to use, 4-7

indexing, 7-34

indexing columns, 4-38

inserting into, 4-9

inserting with createXML() using string, 4-16

inserting with SYS_XMLGEN(), 4-16

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-26

querying with extract() and existsNode(), 4-26

querying XMLType columns, 4-26

queue payloads, 23-6

storage architecture, 1-12

storage characteristics, 4-12

storing data in Oracle XML DB, 4-4

summarized, 1-4

table, 3-3

table storage, 1-10

table, querying with JDBC, 9-4

tables, storing, 5-24

tables, views, columns, 5-14

triggers, 4-37

updating column, example, 4-9

using in SQL SELECT statement, 4-9

views,access with PL/SQL DOM APIs, 8-11

when to use, 4-4

Xpath support, 4-38

XMLType, loading with SQL*Loader, 22-2

XPath

basics, D-6

explained, 1-28

expressions, mapping, 5-58

mapping for extract(), 5-68

mapping for extract() without document order, 5-69

mapping for extractValue(), 5-66

mapping to NULL in, 5-61

mapping, simple, 5-58

rewrites for existNode(), 5-63

rewriting expressions, 5-54

support, 4-38

text(), 5-59

unsupported constructs in query rewrites, 5-55

use for searching data, 1-5

using with Oracle XML DB, 3-5

W3C introducing, C-2

XPath expressions

supported, 5-55

xsi.noNamespaceSchemaLocation, 5-5

XSL

and CSS, D-7

basics, D-2

defined, 1-28

XSL stylesheet, example, D-7

XSLT, 8-12

1.1 specification, D-5

explained, D-5

xsql

include-xml

aggregating results into one XML, 10-51

generating XML from database, 10-52

XSQL Pages Publishing Framework

generating XML, 10-3, 10-51