External table preprocessor on Windows
There are plenty of blog posts about using the pre-processor facility in external tables to get OS level information available
Tag: external
The death of UTL_FILE – part 2
I wrote a post a while back call “The Death of UTL_FILE”, and probably because of it’s click-bait title I
Parsing freeform data in flat files
SQL loader is a very cool utility that has existed for a long time within Oracle to load flat files
A new line on NEWLINE
Recently I was doing a simple external table load using a CSV file, but was getting an interesting error. My
Slow external table access
We had an interesting issue on 12.1.0.1, where users were reporting very slow performance on queries to external tables. When
