| SQL Loader [message #185111] |
Mon, 31 July 2006 01:11  |
vinoth_kumar
Messages: 4
Registered: July 2006
|
Junior Member |
|
|
Hi all,
I have a doubt in SQL Loader.
We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for
a column while loading data using SQL Loader into table or multiple tables.
My requirment is this.
For the first run in SQL Loader, say some 100 records are loaded it has to generate 1 ........ 100 for a column.
For the next run, say some 65 records are loaded it has to generate 1 ...... 65 for the same column. (not as 101 .... 165).
Please help me on this.
Thanks & Regards,
Vinoth
|
|
|
|
| Re: SQL Loader [message #185263 is a reply to message #185111] |
Mon, 31 July 2006 17:06  |
 |
Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
|
You can either use the SQL*Loader sequence or drop and recreate or reset the SQL sequence before each run. I would use the SQL*Loader sequence.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
