O'Reilly logo

Oracle Database 11g: Building Oracle XML DB Applications by Jinyu Wang

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using XMLQuery()

In Oracle XML DB, XQuery expressions need to be evaluated by SQL/XML functions such as XMLQuery():

XMLQUERY (XQuery-expression

     [PASSING value-expression [AS identifier]]

     RETURNING CONTENT

     [NULL ON EMPTY]

     )

The XMLQuery() function has two required arguments, an XQuery expression and a RETURNING CONTENT statement. The value-expression is used in the PASSING expression to pass in a sequence of XML nodes or atomic values to XQuery. You can assign a name alias to the passed-in XML data using the AS operator. RETURNING CONTENT returns the XQuery output. XMLQuery() can operate on different data sources. Normally, XMLQuery() operates on the following types of XML data sources:

  XMLType objects Constructed from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required