I’m currently working on adding support for delimited and positional flat files to ExcelTable. The file, residing as a CLOB inside the database, will be parsed using PL/SQL code. In its simplest, the base algorithm consists in locating field separators (and line terminators) in the input text and extracting data in between. DBMS_LOB.INSTR API may … Continue reading PL/SQL CSV Parsing : To Buffer or Not Buffer
