Hello gurus,
I need to extract the value from thae table having JSON payload
My database version:oracle 11g
email" : "ret@xyx.com" from the authorized_users
create table test_json
(
lic clob);
insert into test_json
values
(
'{
"lic":{
"name": "PO_11018, , TEST_BDC-FGG, (, test.com)",
"license_type": "vfg_dfgg",
"number_of_appliances": 2,
"organization_id": 19933,
"partner_id": "0000DSFDSFSFFSF",
"partner_name": "Test Comp.",
"oracle_part": "TEST_DFGG-RTYY",
"oracle_line": "1.1",
"bill_to_purchase_order_id": "PO_1018",
"order_attributes": {
"sales_order_id": "110881",
"organization_id": 19933
},
"expires_at": "",
"shell_access": false,
"notes": "Order#: 110881, Quote#: 000032435",
"authorized_users": [
{ "email" : "ret@xyx.com","checked":true}
],
"internal_notes": "Order#: 110881, Quote#: 00075418"
}
}');
commit