-
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
-
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
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
SQL*Loader - that's what we used to use before we had external tables, right?
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|