Oracle9i XML Database Developer's Guide

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*Tree, 1-11, 4-6, 5-51

indexing, 3-26

bootstrap ACL, 18-4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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