Re: Sequence Numbers
From: Wolfram Diestel <wdiestel_at_debis.com>
Date: Thu, 18 Nov 1999 13:06:12 +0100
Message-ID: <3833EBB4.568EFFEE_at_debis.com>
Date: Thu, 18 Nov 1999 13:06:12 +0100
Message-ID: <3833EBB4.568EFFEE_at_debis.com>
BHAVESH GOSAR wrote:
>
> All,
>
> We have a Sequence which is defined and the Sequence is generated
> from the application using <sequence_name>.NEXTVAL.
>
> We have data coming thru the Web-for...going thru an Interface
> table into the Application...How do we use the same
> <sequence_name>.NEXTVAL
> in the SQLLoader so that an Unique Seq. Number is generated
> irrespective of how the data is fed in the application...??
[Quoted] You could use different ranges (sequences) for the records comming from your application and the web. Another advantage of this would be, that you see, where a record came from.
Wolfram.
-- Wolfram Diestel, debis GEI, GS Leipzig e-mail: <wdiestel_at_debis.com> Telefon: 0341/1275-450Received on Thu Nov 18 1999 - 13:06:12 CET