This discussion is archived
1 Reply Latest reply: Dec 26, 2012 1:06 AM by 971895 RSS

sqlldr NULLIF condition for the word 'NULL' in quotes

943610 Newbie
Currently Being Moderated
Hi.
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points