CREATE TABLE j_purchaseorder
(id RAW (16) NOT NULL,
date_loaded TIMESTAMP WITH TIME ZONE,
po_document CLOB
CONSTRAINT ensure_json CHECK (po_document IS JSON));
-----插入json数据
SQL> INSERT INTO j_purchaseorder
2 VALUES (SYS_GUID(),
3 SYSTIMESTAMP,
4 '{ "PONumber" : 1600,
5 "Reference" : "ABULL-20140421",
6 "Requestor" : "Alexis Bull",
7 "User" : "ABULL",
8 "CostCenter" : "A50",
9 "ShippingInstructions" : { "name" : "Alexis Bull",
10 "Address": { "street" : "200 Sporting Green",
11 "city" : "South San Francisco",
12 "state" : "CA",
13 "zipCode" : 99236,
14 "country" : "United States of America" },
1