| SqlLoader: Skipping columns in between [message #71688] |
Wed, 18 December 2002 23:29  |
Deborah
Messages: 18
Registered: June 2002
|
Junior Member |
|
|
Hi,
I have the data file in tab delimited format.
I have 10 fields in this input file. But I
do not want 3rd to 8th fields. My table has
only fields F1, F2, F9 and F10.
How should the sqlloader script look like?
Thanks.
Debby
|
|
|
|
| Re: SqlLoader: Skipping columns in between [message #71689 is a reply to message #71688] |
Thu, 19 December 2002 01:21  |
Shri G
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
Hello Debby,
If you are using the Oracle 8i version, all you need is to use the 'filler' option to skip the unwanted columns;
In your case the CTL file would look like:
----------------------------------------------------
LOAD DATA
INFILE 'test.csv'
INTO TABLE TEST
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(F1, F2, col3 FILLER,col4 FILLER....col8 FILLER,F9,F10)
------------------------------------------------------
Please check the sql-loader syntax for TAB delimited file and replace the above "FIELDS TERMINATED BY ' '" section. Thanks,
Shri
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
