SQL LOader script

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

use a sequence and call nextval

Quote:

---

Originally Posted by davey23uk

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

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

Quote:

---

Originally Posted by WilliamR

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.