Home » RDBMS Server » Server Administration » external table...
external table... [message #214645] Wed, 17 January 2007 06:18
suvv
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
header.

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: Thu Dec 08 03:52:31 CST 2016

Total time taken to generate the page: 0.09593 seconds