Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load multi line column

taohikoMar 19 2014 — edited Apr 8 2014

Hi All

The question seem like the normal case but source file that is complicated, below is target table structure

COL_A varchar2(100),

COL_B timestamp(6),

COL_C CLOB,

COL_D varchar2(100),

COL_E timestamp(6)

The problem is column COL_C that is CLOB and source file contain multi line value as below example

AAAA,2014-02-01 11:00:28.28,,,2013-02-11 20:01:21.10

BBBB,2014-02-01 12:00:28.28,"This is

Multi Line

Text",,2013-02-11 21:01:21.10

CCCC,2014-02-01 11:00:28.28,,,2013-02-11 20:01:21.10

The source file will add double quotoes when column COL_C have a value if not, will leave it blank.

I tried to use CONTINUEIF LAST != '"' but it's not work because the first line did not contain any double quotes and sqlldr will find double quotes in second line that is not correct.

Could you please suggest any solution to load data as above by sqlldr?

Thank you in advance,

Hiko

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2014

Added on Mar 19 2014

#database-key-features, #export-import-sql-loader-external-tables

6 comments

3,468 views