Skip Headers
Oracle® Database SQL Language Reference
11g Release 1 (11.1)

Part Number B28286-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

XMLEXISTS

Syntax

Description of xmlexists.gif follows
Description of the illustration xmlexists.gif

XML_passing_clause::=

Description of xml_passing_clause.gif follows
Description of the illustration xml_passing_clause.gif

Purpose

XMLExists checks whether a given XQuery expression returns a nonempty XQuery sequence. If so, the function returns TRUE; otherwise, it returns FALSE. The argument XQuery_string is a literal string, but it can contain XQuery variables that you bind using the XML_passing_clause.

The expr in the XML_passing_clause is an expression returning an XMLType or an instance of a SQL scalar datatype that is used as the context for evaluating the XQuery expression. You can specify only one expr in the PASSING clause without an identifier. The result of evaluating each expr is bound to the corresponding identifier in the XQuery_string. If any expr that is not followed by an AS clause, then the result of evaluating that expression is used as the context item for evaluating the XQuery_string.

See Also:

Oracle XML DB Developer's Guide for more information on uses for this function and examples