Oracle SQL :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(
COLUMN Building FORMAT A20
SELECT
w.warehouse_spec.extract(’/Warehouse/Building/text()’).getStringVal()
"Building"
FROM warehouses w
Building
--------------------
Owned
