X

XML, 2, 3, 9, 35, 50, 59–60, 90, 96, 200, 270, 333–337, 570, 571, 572–573, 601

application programming interfaces (APIs) and, 60

BLOBs and CLOBs in, 59

columns using XML data and, 91, 410–411

Data Manipulation Language (DML) and, 333

data type of (XML), 372–373, 454, 461–462, 599–600, 599, 608, 609

Database Partitioning feature and, 373

DELETE and, 333, 335

INSERT and, 333, 334

pureXML and, 38, 60. See also pureXML, 60

relational data vs., 91

SELECT and, 333

shredding of documents in, 57–60, 96, 572, 573

SQL and, 255–364. See also XQuery

table data and, XQuery for, 60, 335. See also XQuery

UPDATE and, 333, 334

VALIDATED predicate and, 410–411

XML Extender for, 55, 57–58, 95, 572

XMLEXISTS and, 336–337, 336

XMLPARSE () and, 333, 334, 372, 455, 601

XMLQUERY() and, 336

XMLSERIALIZE () and, 372

XMLTABLE() and, 336

XMLVALIDATED() and, 410–411, 609

XQuery and, 60, 255–364. See also SQL; XQuery

XML Extender, 55, 57–58, 95, 572

XMLEXISTS, 336–337, 336

XMLPARSE (), 333, 334, 372, 455, 601

XMLQUERY(), 336

XMLSERIALIZE (), 372

XMLTABLE(), 336

XMLVALIDATED(), 410–411, 609

XQuery, 9, 40, 52, 60, 255, 335–337, 363–364, 571, 598–599

authorities and, 105

Database Administrator (DBADM) authority and, 110–111

INSERT and, 337

SELECT and, 337

uses for, 337

WHERE clause and, 337

XMLEXISTS and, 336–337

XMLQUERY() and, 336

XMLTABLE() and, 336