sqlloader - load records with quotes " "
- From: susan lam <susanzlam@xxxxxxxxx>
- To: Oracle-L@xxxxxxxxxxxxx
- Date: Wed, 9 Feb 2005 11:01:28 -0800 (PST)
hi,
Is there a way to load the following records using
sqlldr?
"jack "King",","LEE"
The record should be loaded in the table as :
field1 - jack "King",
field2 - LEE
Control file:
LOAD DATA
APPEND INTO TABLE testing
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(a,b)
Data file format:
<field1>,<field2>
thanks.
susan
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
//www.freelists.org/webpage/oracle-l
Other related posts:
