SQL LOader script

[malay_biswal]

Hi,
I've arequirement of loading some data from csv file to a table. BUt at the same time i've to load the serial#. For example, in csv file i've emp_name,salary,designation as john, 8000, consultant. In table i need to load 1,john,8000,consultant. where 1 is serial# and it's autoincreamental. That means in next row it'll be 2,3,4....

How can i do this. Any advice highly appreciated.

Thanks

[davey23uk]

use a sequence and call nextval

[jmodic]

use a sequence and call nextval

Or use SQL*Loader's own SEQUENCE generator (it might be faster than calling database's sequence NEXTVAL).
http://download-west.oracle.com/docs...06.htm#1008321

[WilliamR]

SQL*Loader - that's what we used to use before we had external tables, right?

[jmodic]

SQL*Loader - that's what we used to use before we had external tables, right?

... and that's what we still use today when the source files are on client's machines, not on the database server.