Image

CHAPTER

8

XML Query

Oracle XML DB 11g XQuery supports the W3C XML Query (XQuery) 1.0 standard (http://www.w3.org/TR/xquery/). In Oracle Database 11gR2, XQuery is supported mainly by two SQL/XML functions, XMLQuery() and XMLTable(). The XMLQuery() function takes an XQuery expression as the input to query XML. The XMLTable() function maps the result of an XQuery evaluation into relational rows and columns.

In Oracle Database 11gR2, XQuery functions are replacing Oracle SQL functions and becoming the standard to query XML in the Oracle database. The XMLQuery() and XMLTable() functions replace the SQL functions extract() and XMLSequence() respectively. ...

Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.