Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 43 of 177
extract_xml::=
EXTRACT
(XML) is similar to the EXISTSNODE
function. It applies a VARCHAR2
XPath string and returns an XMLType
instance containing an XML fragment.
The following example extracts the value of the /Warehouse/Dock
node of the XML path of the warehouse_spec
column in the sample table oe.warehouses
:
SELECT warehouse_name, EXTRACT(warehouse_spec, '/Warehouse/Docks') "Number of Docks" FROM warehouses WHERE warehouse_spec IS NOT NULL; WAREHOUSE_NAME Number of Docks -------------------- -------------------- Southlake, Texas <Docks>2</Docks> San Francisco <Docks>1</Docks> New Jersey <Docks/> Seattle, Washington <Docks>3</Docks>
Compare this example with the example for EXTRACTVALUE, which returns the scalar value of the XML fragment.
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|