|
|
|
|
|||||||
| Forums | Portal | Register | Rules & FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sequence number generation on a key column | sbasetty | Shell Programming and Scripting | 6 | 03-27-2008 08:09 AM |
| Random number generation in ksh | mervin2006 | UNIX for Dummies Questions & Answers | 2 | 04-26-2007 11:02 PM |
| A SQL Loader Script | LiquidChild | Shell Programming and Scripting | 2 | 04-23-2007 03:17 AM |
| Random number generation | tej.buch | High Level Programming | 1 | 02-13-2006 06:07 AM |
| SQL loader error | sveera | Shell Programming and Scripting | 4 | 04-19-2005 01:04 PM |
 |
|
|
LinkBack | Thread Tools | Display Modes |
07-30-2006
|
|||
|
|||
|
SQL Loader Auto Number Generation
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). Help me on this. Thanks & Regards, Vinoth 
|
| Forum Sponsor | ||
|
|
|
08-01-2006
|
||||
|
||||
|
you can use oracle sequence from 1-100 and then 1-65 at creation of the sequence.keep MAXVALUE 100 and CYCLE 100.after reaching of value at 100 the next value will be one.read more about sequence.
|
||||
| Google UNIX.COM |
Linear Mode
