Total Pageviews

January 8, 2015

1/08/2015 12:30:00 AM
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...