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 be longer than 32KB EXAMPLE Write an array attribute that contains JSON declare l_value apex_application_global.vc_arr2; begin l_value(1) …

First Day of the YEAR by ROUND function This function works similar to ROUND of numbers, if the month is geater than six (6) then return the day of next year else it returns day of current year. SELECT ROUND (SYSDATE, 'YEAR') "As of day" FROM DUAL; / AS OF DAY 1/1/2021 SELECT ROUND (TO_DATE …

APEX_JSON Nested JSON data parsing Sample JSON { "RAW": { "LEVEL_1": "2", "LEVEL_1_ARRAY": [{ "LEVEL_2": { "LEVEL_2_A": "Ashish", "LEVEL_2_ARRAY": [{ "LEVEL_3_A": "00", "LEVEL_3_B": "ABC" }, { "LEVEL_3_A": …

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