Skip to Main Content
Forums

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!

How to add expressions to CLOB columns in SQLLOADER Control file

Sarath Gonuguntla-OracleFeb 10 2015 — edited Feb 13 2015

Hi All,

Our requirement is ,

1) we have a default value for a CLOB column (For Ex : '1234')

2) In our Input file, we have some column values  that are empty.

For Ex :

Name(varchar)    Value(clob)

       a1               clob1

       a2

       a3               clob3

3) Our control file is such that when imported above csv using SQL-LOADER,our data in DB should be as below

Name           Value

   a1              clob1

   a2              1234

   a3              clob3

How can we achieve this ?

I read SQL strings are not supported on CLOB.

Is there any SQL-LOADER specific expressions/procedure to achieve this?

Please help on this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2015
Added on Feb 10 2015
#database-key-features, #export-import-sql-loader-external-tables
4 comments
1,684 views