APEX_DATA_PASER | Ontoor Solutions Blogs

How to Parse Json Using Apex Data Parser in Oracle?

Posted by - Ashish Sahay Apr 19, 2020 APEX_DATA_PASER APEX PLSQL SQL

How to Parse Json Using Apex Data Parser in Oracle? Sample JSON 1{ 2 "items":[ 3 { 4 "uri":{ 5 "$ref":"https://apex.oracle.com/pls/apex/ashish_portfolio/hr/employeesfeed/7782" 6 }, 7 "empno":7782, 8 "ename":"CLARK" 9 }, 10 { 11 "uri":{ 12 …
Read More
Apex Data Parser - How to Parse XLSX and CSV

Posted by - Ashish Sahay Apr 18, 2020 APEX_DATA_PASER APEX PLSQL SQL PLUGINS TEMPLATES

Apex Data Parser - How to Parse XLSX and CSV? PARSE Function This is the main parser function. It allows to parse XML, XLSX, CSV or JSON files and returns a generic table of the following structure: Structure of parser return LINE_NUMBER, COL001, COL002, COL003, COL004 … COL300 We have line_number and 300 …
Read More