Inserting XML Data Type

CREATE TABLE warehouses (

warehouse_id NUMBER(3),
warehouse_spec SYS.XMLTYPE,
warehouse_name VARCHAR2 (35),
location_id NUMBER(4));


INSERT into warehouses (warehouse_id, warehouse_spec)
VALUES (100, sys.XMLTYPE.createXML(
’
Owned’));


COLUMN Building FORMAT A20
SELECT
w.warehouse_spec.extract(’/Warehouse/Building/text()’).getStringVal()
"Building"
FROM warehouses w


Building
--------------------
Owned