Friends,
I have the classic case of a comma separated text file which I want to upload
and I need to know how can I enforce the following behavior of the SQL Loader:
1. To ignore the first row of the data file (which contains the column titles)
2. Avoid uploading of a column from the middle
you can use the skip option of the sql loader. in ur case it should be
skip=1(if headings are also separated by commas)
can have the full help by typing sqlldr help=y at the command prompt.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Could you not simply open the .csv file and manually delete the first row?
As for your second question, I believe you can just not mention the column
you want to leave out in the control file.
HTH
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 08:35
To:
In a recent mail on a similar topic someone said that in 8i there is a
FILLER field in SQL*Loader that allows you to jump over a column. Prior to
8i you are stuck.
I have been recommended a brand new book on SQL*Loader. Not yet bought or
read it.
Jonathan Gennick Sanjay Mishra
O'Reilly
