Re: Retrieving records in order they were placed.

I don't think you need to worry about sequence numbers wrapping. The maximum value for an Oracle sequence is 10^27,

At 1,000,000 entries I make that a lifetime of about 10^13 years before the sequence wraps.

Might have to handle the Y10K problem before then though.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

b_rich2_at_my-deja.com wrote in message <7m4rcj$9gd$1_at_nnrp1.deja.com>...
>
>I then though of having a sequence number associated with each record,
>increasing one by one with each record stored. This will work well until
>the sequence numbers begin to wrap. If they are retrieved in order of
>sequence number, and then they wrap, the records entered after the wrap
>(sequences 1,2,3,4 etc) will all of a sudden be pulled out before the
>earlier records with high sequence numbers.
Received on Fri Jul 09 1999 - 08:07:42 CDT