Escape character while loading data using sqlloader

From: rita <>
Date: Wed, 30 Sep 2009 05:43:28 -0700 (PDT)
Message-ID: <>

Hi all,

I am trying to load the data from a csv file to database.

my data is:


I want it in databse as
aaaa dd"d
hhh jbbb

My control file is:
LOAD DATA INFILE 'SHEET1.csv' TRUNCATE INTO TABLE temp fields terminated by "," optionally enclosed by '"' TRAILING NULLCOLS

I am using \ as escape character.
but if try to load the data, the data having \" does not get loaded

any pointers will be appreciated.

thanks. Received on Wed Sep 30 2009 - 07:43:28 CDT

Original text of this message