-
SQLLDR want double quotes in string
Hello All,
What is the proper way to code a control file (or my data) so that I can include a double quote with the data? I'm erroring out right now.
Below is a sample.
Thanks,
P
Control file
============
load data
infile test.dat
REPLACE
into table test
FIELDS terminated by "," optionally enclosed by '"'
(TEST_PK
,TEXT
)
Data file
=========
"15","If you answered "Yes," to any of the above, please provide details on a separate sheet.",
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|