Re: Unique sequence number per datafile using SQL Loader
From: Andy Hardy <junkmail_at_[127.0.0.1]>
Date: Wed, 25 Oct 2006 19:42:30 +0100
Message-ID: <453fb016$0$8716$ed2619ec_at_ptn-nntp-reader02.plus.net>
Date: Wed, 25 Oct 2006 19:42:30 +0100
Message-ID: <453fb016$0$8716$ed2619ec_at_ptn-nntp-reader02.plus.net>
radhika.penagonda_at_gmail.com wrote:
> That will create a new sequence number for each record.
> What I need is just one sequence number for each file. (All records in
> that file will have the same number)
Only if you assign the sequence number per record, you could just pick the sequence number once per load. Received on Wed Oct 25 2006 - 20:42:30 CEST