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>
"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>