SQL Loader Auto Number Generation

vinoth_kumar · #1 (**permalink**) 07-31-2006

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

tmarikle · #2 (**permalink**) 07-31-2006

This kind of sounds a little like classroom work.

Dhruva · #3 (**permalink**) 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.

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 12:09 PM
Random number generation in ksh	mervin2006	UNIX for Dummies Questions & Answers	2	04-27-2007 03:02 AM
A SQL Loader Script	LiquidChild	Shell Programming and Scripting	2	04-23-2007 07:17 AM
Random number generation	tej.buch	High Level Programming	1	02-13-2006 10:07 AM
SQL loader error	sveera	Shell Programming and Scripting	4	04-19-2005 05:04 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by