perl for processing sqlplus spool output
By Katsumii-Oracle on 12 19, 2013
When I wrote my bash script below 3 monthes ago,
you need to salvage data from sqlplus spool file
I thought I googled enough not to reinvent the wheel.
But that wasn't enough! One of my colleague's mail lead me to another colleague's blog entry.
perl seemed like the best fit as it’s easy, cross platform, and made for text files.
My bash script runs on Windows Cygwin so it's somewhat cross platform. But I recommend using Tyler's perl.
It's more readable and it seems it can handle many corner cases.
Now I remember that there was an internal discussion as to what's the best language to write 'one-off' script.
Kind of consensus at that time was 'perl' as far as Oracle Database is concerned because perl gets installed
I think python is OK now in Exadata env.