Thanks, John. Great article. I do use Copy_data a lot for csv/text files. However, I was wondering if you have a similar solution when the file has a header (data values not column names), detail and a trailer? How can one handle such files?
Thank you for the feedback. It has been a long time since working with these kinds of files. I think you are going to have to process the file with custom PL/SQL.