Total Pageviews

January 8, 2015

1/08/2015 02:00:00 PM



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(
'Owned'));


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


Building
--------------------
Owned
 
Related Posts Plugin for WordPress, Blogger...