sqlloader - load records with quotes " "

From: susan lam <susanzlam_at_yahoo.com>
Date: Wed, 9 Feb 2005 11:01:28 -0800 (PST)
Message-ID: <20050209190129.28353.qmail@web53303.mail.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 09 2005 - 14:04:13 CST