Using Oracle Sequence in SQL Loader?

Question

Hi,

I am using SEQUENCE keyword in SQL Loader control file to generate primary keys. But for a special scenario I would like to use Oracle sequence in the control file. The Oracle documentation for SQL Loader doesn't mentioned anything about it. does SQL Loader support it?

Answer 1

I don't think so, but you can assign the sequence via the on insert trigger unless this is a direct path load.