Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 39 of 166
existsnode::=
existsnode
The EXISTSNODE
function 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
string designating a path.
The return value is NUMBER
:
The following example tests for the existence of the /Warehouse/Dock
node in the warehouse_spec
column XML path of the sample table oe.warehouses
:
SELECT warehouse_id, EXISTSNODE(warehouse_spec, '/Warehouse/Docks') "Loading Docks" FROM warehouses WHERE warehouse_spec IS NOT NULL; WAREHOUSE_ID Loading Docks ------------ ------------- 1 1 2 1 3 1 4 1
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|