Re: sqlldr - sequence nextval

Use a befroe insert trigger on the column you want to sequence. Look at the PL/SQL docs

--
Ron Reidy
Oracle DBA

Ken Chesak wrote:


> I would like to use sequence.nextval to update column value in sqlldr.

>  The column does not exist in the input file.

> 

> LOAD DATA

> INFILE  'gws_case.dat'

> APPEND

> INTO TABLE benefit_case

> FIELDS TERMINATED BY X'09'

> 

> (

>         id_benefit_case SEQUENCE(MAX,1),    <<< this works

>         case_no ,

>         id_seq 

> )

> 

> But I would like to use something like this, but I cant figure out the

> right syntax:

>          id_benefit_case SEQUENCE(sq_benefit_case.nextval) 

> 

> I can use the SEQUENCE(MAX,1) but then I would need to update the

> sequence sq_benefit_case to the correct value after running sqlldr.

> 

> Thanks