how to load file data into single column using sql loader
525708Feb 23 2009 — edited Feb 24 2009Dear Members,
I am facing problems with sql loader while loading data.
Suppose my file contains 35 columns and it is a tab delimited file.
I want to load all the 35 columns in a single column in the table. How can i do that using sql loader.
when i tried to use the below code in ctl file it loaded one character which is tab(chr(9)) in col2:
LOAD DATA INFILE 'VCF40_049.txt'
APPEND
INTO TABLE apps.test
(col1 "ap_credit_card_trxns_s1.nextval",
col2)
Here col2 is the column in table test where i want to load all the file data(35 columns).
How can we do the above using sqlldr.
Thanks
Sandeep