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.",