Posted inAPEX

APEX_JSON.WRITE_RAW

Referred from Oracle Standard Document. APEX_JSON write unescaped JSON write an unescaped array attribute. use the escaping write() procedures instead, if possible. PARAMETERS p_value The value to be written which can…
September 25, 2021
Posted inAPEX

Generating JSON using APEX_JSON

Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: Copy CodeCopiedUse a different BrowserCREATE TABLE DEPT (…
February 26, 2020
Posted inAPEX

APEX_JSON Nested parsing

APEX_JSON Nested JSON data parsing Sample JSON Copy CodeCopiedUse a different Browser{ "RAW": { "LEVEL_1": "2", "LEVEL_1_ARRAY": [{ "LEVEL_2": { "LEVEL_2_A": "Ashish", "LEVEL_2_ARRAY": [{ "LEVEL_3_A": "00", "LEVEL_3_B": "ABC" }, {…
February 26, 2020