Home » RDBMS Server » Server Administration » external table...
external table... [message #214645] Wed, 17 January 2007 06:18
Messages: 17
Registered: October 2006
Junior Member
I can successfully create the external table and read the data.
However I would like to place a header in the spooled file but the only method
I have found to ignore the header is to use the "SKIP" parameter. I would
rather not use this as it hard codes the number of lines I reserve for a

Is there another method to add a comment to a external tables file and have the
selects on the file ignore the comments?
Could I use "LOAD WHEN ( column1 != '--' )" as each comment line begins with a
double dash?
Previous Topic: Error in usage of utl_file from procedure
Next Topic: grant
Goto Forum:

Current Time: Fri Jul 28 08:07:09 CDT 2017

Total time taken to generate the page: 0.13019 seconds