APEX_DATA_PARSER performance issues. 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 with small files. Recently I needed to process and parse a file …

How to parse XML using APEX_DATA_PARSER? Get the XML data. <?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> …