Loading a database sequence into a column during sql loader
Posted on 2004-08-27
I want to load the NEXTVAL of the sequence stored in that database into a column of the table iam loading using sql loader.
The seq name is:
The column name is seq_no. So, I was trying this :
TRUNCATE INTO TABLE conv
FIELDS TERMINATED BY ","
SEQ_NO "select conv_seq.nextval from dual"
Tried all the combinations i could. didn't work. so, asking for your help.