Hi All,
I have small problem. Using Oracle spool files, I am able to transfer output of sql queries on to text files.
My problem starts when I need to merge and sort these files
Reason:
Oracle outputs a blank row (all spaces) then a row with field names, the a row with dashes(-) then a blank row.
So the actual data comes after the first four lines.
And after the data comes a blank row( all spaces), number of rows returned, and then a blank row.
How do I extract only the useful data, and leave out the top 4 and botton 3 rows from the text file.
Please suggest
Kapil
_______________________________________________ ilugd mailinglist -- [EMAIL PROTECTED] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[email protected]/
