Index
S
Sample database schemas, installing, 137–138
Samples, creating users to run XMLType, 138
SAX (Simple API for XML), 16
SAX, accessing XML with, 15, 28–42
SAX APIs, 31–37
SAX APIs in C, Oracle, 37–42
SAX Level 1 and Level 2, 28–31
SAX parsing and printing, 346–348
SAX specification, 531–532
SAX vs. DOM, 108
SAX XML processing, 511–515
Schema annotations, XML, 165–168
Schema-based types, XML, 153
Schema-based XMLTypes, creating XML, 186
Schema built-in datatypes, XML, 69–70
Schema evolution, 185
Schema language, XML, 66–68
Schema registration, XML, 160–165
Schema specification, W3C XML, 532
Schema validation, XML, 172–173
Schemascreating database, 317–321
creating glossary, 283–284
creating messaging, 324–325
creating user, 301–302
database, 11–14
designing, 79
designing FAQ, 269–271
generating XML, 209–210
input XML, 43
installing sample database, 137–138
mapping database, 12–14
mapping DTDs to database, 75–76
mapping XML documents to database, 12–14, 76
processing documents valid against remote, 361
registering FAQ, 272–273
setting up database, 482–485
validating XML with XML, 63–81
Searchesadvanced text, 237–238
optimizing Oracle Text, 236
Oracle Text, 239
Searches, XPath-based, 220–229, 239
optimizing XPath-based queries using indexes, 227–229
searching XML document using XPath, 221–224
XPath-based searching, 224–226
Searching, full text, 230–238
advanced text searches, 237–238
optimizing Oracle Text searches, 236
Oracle Text searching, 235–236
searching XML using Oracle Text, 231–234
Searching XMLdata, 155, 219–240
documents using XPath, 221–224
using Oracle Text, 231–234
Searching, XPath-based, 224–226
Secure connections, creating more, 126
Security management, 248–251
protecting data in Oracle XML DB Repository, 248–250
securing DBUri operations, 250–251
Security protection, setting up, 498
Serialization, 107–108
Serversbuilding web services in database, 497–498
SOAP, 99–100
Servicesdebugging web, 491–492
publishing first database web, 482–492
publishing PL/SQL web, 485–489
web, 289–311
Services, building different types of web, 498–499
Services, building PL/SQL web, 481–499
consuming web services within Oracle databases, 492–497
extending application, 497–499
publishing first database web service, 482–492
ServletsAQ, 101
inserting XML documents with XSQL,122
installing XSQL, 118
submitting queries to XSQL, 118–119
updating data with XSQL, 122–125
SGML (Standard Generalized Markup Language), 4
SOAP (Simple Object Access Protocol), 11, 96
using and Oracle database, 100–103
using from PL/SQL, 103
vs. JAX-RPC, 104
vs. JMS, 104
SOAP and AQ, XML gateway application with, 313–342
conventional solution, 314–315
creating framework, 317–323
designing framework, 314–317
extending application’s functionality, 341–342
extending framework, 332–340
interfacing to Internet, 316–317
stream-based one-step solution, 315–316
SOAP and Oracle XDK, using, 99–100
SOAP clients, 99
SOAP handlers, 100
SOAP, introducing, 96–98
literal, encoded SOAP messages, 96–98
one-way, two-way SOAP messaging and RPCs, 98
SOAP messagesconstructing, 493
sending out using UTL_HTTP, 494–497
submitting, 341
SOAP servers, 99–100
SOAP, XML messaging and RPC with, 95–104
best practices, 104
introducing SOAP, 96–98
using SOAP and Oracle database, 100–103
using SOAP and Oracle XDK, 99–100
Special characters, 205–206
Specificationscreating PL/SQL, 504
ISO SQL/XML, 534
Java community process, 534
SAX, 531–532
W3C, 530–534
W3C DOM, 531
W3C namespace, 532
W3C XML, 530–531
W3C XML Pipeline Definition Language, 533
W3C XML query, 532–533
W3C XML schema, 532
W3C XSLT and XPath, 533
Specifications, XML standards bodies and open, 529–535
ISO SQL/XML specifications, 534
Java community process specifications, 534
miscellaneous helpful resources, 535
Oracle technical resources, 535
W3C specifications, 530–534
Splitter mode, running cppextract in, 460
SQL command, 169
SQL data, generating XML from, 190–199, 199–206
SQL utility, XML, 177–182
canonical mapping, 177–179
dividing XML documents into fragments, 180–182
object views, 179–180
SQL/XML functions, 190–199, 206–208
SQL/XML processing, 146–147
SQL-XML, XQuery versus, 94
SQL*Loader, 170–171
Standard Generalized Markup Language (SGML), 4
Standards, XML database and, 148–149
Static areas, creating, 300–301
StAX (Streaming API for XML), 16, 45
accessing XML with, 15, 45–47
Stored procedurescreating Java, 502–504
debugging Java, 516–517
running Java, 504–505
simplifying deployment of Java, 505–507
when to use Java, 515
Storing XML data, 150–154, 157–188
Streaming API for XML (StAX), 45
Stylesheetscompiling with xslcompile, 411–414
creating XSL, 383–385
transforming XSQL output with, 119–121
XSLT, 55–56, 379–380
Systems, parsing XML from local file, 467–471
SYS_XMLAGG(), 197
SYS_XMLGEN(), 193