Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Export/Import/SQL Loader & External Tables
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 26, 2012 9:06 AM by
sqlldr NULLIF condition for the word 'NULL' in quotes
Dec 25, 2012 2:32 PM
In my ctl file I have the line:
OPTIONALLY ENCLOSED BY '\'' AND '\''
the csv file:
NULL 'NULL' 'x,|''x'
How to tell sqlldr to insert first value as NULL and the second value as string?
Edited by: 940607 on 25.12.2012 6:30
Edited by: 940607 on 25.12.2012 6:32
This content has been marked as final.
Show 1 reply
Re: sqlldr NULLIF condition for the word 'NULL' in quotes
Dec 26, 2012 9:06 AM
in response to
we can do it external table...