APEX_JSON Nested JSON data parsing Sample JSON 1{ 2 3 "RAW": { 4 5 "LEVEL_1": "2", 6 7 "LEVEL_1_ARRAY": [{ 8 9 "LEVEL_2": { 10 11 "LEVEL_2_A": "Ashish", 12 13 "LEVEL_2_ARRAY": [{ 14 15 "LEVEL_3_A": "00", 16 17 "LEVEL_3_B": …

Read More

Generating JSON using APEX_JSON Sample tables from Oracle Create Two table based on below query and Inserted some record for demo purpose: 1CREATE TABLE DEPT ( 2 DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY, 3 DNAME VARCHAR2(14), 4 LOC VARCHAR2(13) 5) ; 6 7 8CREATE TABLE EMP ( 9 EMPNO NUMBER(4) CONSTRAINT PK_EMP …

Read More