In my previous blogs , we have seen how easy is to parse the excel and CSV files using APEX_DATA_PARSER. All options are declarative and easy to use. I have been using this utility for a long time but the use involved... Read more
How to Parse Json Using APEX Data Parser in Oracle? Sample JSON Parsing Query file_content holds the whole JSON data. Output You might like Read more
How to parse XML using APEX_DATA_PARSER? Get the XML data. Parsing Query You might also like Read more
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... Read more