how to load specific data with Oracle DB with sqlldr?
Posted on 2015-01-26
The table structure is
A number(5) DEFAULT 0 NOT NULL,
C number(6) NOT NULL
Have the following data to be loaded:
11,""This is a test, test twice,"", 101
,""This is a test,test twice. "That is also a hard test", isn't it?"", 105
It looks the delimiter like comma for the control file, but it applies everywhere except the middle part which are double double quotation marks "" "". Inside the double double quotation marks there are possibly the commas.
Can any gurus shed some lights on this situation on how to write the control file?
Thanks in advance.