SQLLDR

Dear All,

  I have a table T01 (col1 VARCHAR2(10), col2 VARCHAR2(10) ).

  I have a data file with two columns delimited by "," like (12345,68989)

  I need to import the data into this table by using SQLLDR , and update the col2 from the data file where col1 = 12345

  How to use the control file to write update / where condition

  I used like this :

  LOAD DATA
  INFILE data.txt
  APPEND
  INTO TABLE T01
  ( b  POSITION(8:13)   char
  )

Where ?

Thanks

Claude