| SQL-Loader - URGENT [message #69766] |
Mon, 04 March 2002 01:39  |
Rahul Desai
Messages: 26
Registered: March 2002
|
Junior Member |
|
|
Hi all,
I have a data file, where all the data is enclosed in double quotes. The columns are separated by tabs.
It looks like :
"Col1" "Col2" "Col3"
"abcd" "defg" "hijk"
"mnop" "qrst" "uvwx"
I want the data to be loaded in the Oracle Database, but without the double quotes using the SQL Loader.
My control file goes like this :
LOAD DATA
INFILE 'c:myprojectnewrecords.txt'
APPEND INTO TABLE MY_TABLE
FIELDS TERMINATED BY 't'
TRAILING NULLCOLS
( col1 FILLER optionally enclosed by '"',
col2 optionally enclosed by '"',
col3 optionally enclosed by '"')
How can I achieve this? Any pointers?
Thanks and regards,
Rahul Desai
|
|
|
|
| Re: SQL-Loader - URGENT [message #69770 is a reply to message #69766] |
Mon, 04 March 2002 11:53  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi
use X'9'
as the Terminated by ...
like
LOAD DATA
INFILE 'c:myprojectnewrecords.txt'
APPEND INTO TABLE MY_TABLE
FIELDS TERMINATED BY X'9'
TRAILING NULLCOLS
( col1 FILLER optionally enclosed by '"',
col2 optionally enclosed by '"',
col3 optionally enclosed by '"')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
