Oracle APEX - Parsing fixed-width formatted files
Introduction
This blog post focuses on how to parse a fixed-width formatted file using Oracle's APEX, SQL and PL/SQL to make it as efficient as possible.
What is a fixed-width formatted file?
The fixed-width format is a defined format in which data i...
lmoreaux.hashnode.dev8 min read
Haniel Burton
Senior Oracle APEX Developer @Insum
Very interesting and common use case! External tables are also an option that could be faster, but it requires placing the file in a directory object.