Posted inAPEX ORACLE

How to Parse JSON Using APEX Data Parser in Oracle?

How to Parse Json Using APEX Data Parser in Oracle? Sample JSON Copy CodeCopiedUse a different Browser{ "items":[ { "uri":{ "$ref":"https://apex.oracle.com/pls/apex/ashish_portfolio/hr/employeesfeed/7782" }, "empno":7782, "ename":"CLARK" }, { "uri":{ "$ref":"https://apex.oracle.com/pls/apex/ashish_portfolio/hr/employeesfeed/7839" }, "empno":7839,…
April 19, 2020
Posted inORACLE

How to Parse XML in Oracle

How to parse XML using APEX_DATA_PARSER?  Get the XML data. Copy CodeCopiedUse a different Browser<?xml version="1.0" encoding="UTF-8"?> <DATA> <ROW> <EMPNO>7839</EMPNO> <ENAME>KING</ENAME> <HIREDATE>1981-11-17</HIREDATE> <SAL>5000</SAL> <DEPTNO>10</DEPTNO> </ROW> <ROW> <EMPNO>7698</EMPNO> <ENAME>BLAKE</ENAME> <HIREDATE>1981-05-01</HIREDATE> <SAL>2850</SAL>…
April 19, 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