1 Reply Latest reply: Dec 26, 2012 3:06 AM by 971895 RSS

    sqlldr NULLIF condition for the word 'NULL' in quotes

    943610
      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