Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 40 of 177
existsnode::=
EXISTSNODE
determines whether traversal of the document using the path results in any nodes. It takes as arguments the XMLType
instance containing an XML document and a VARCHAR2
XPath string designating a path.
The return value is NUMBER
:
The following example tests for the existence of the /Warehouse/Dock
node in the XML path of the warehouse_spec
column of the sample table oe.warehouses
:
SELECT warehouse_id, warehouse_name FROM warehouses WHERE EXISTSNODE(warehouse_spec, '/Warehouse/Docks') = 1; WAREHOUSE_ID WAREHOUSE_NAME ------------ ----------------------------------- 1 Southlake, Texas 2 San Francisco 4 Seattle, Washington
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|