Re: Auto-increment sequence

From: Peter Gulutzan <pgulutzan_at_ocelot.ca>
Date: 15 Nov 2002 16:35:32 -0800
Message-ID: <36c478c6.0211151635.31f70252@posting.google.com>

Brian Peasland <oracle_dba_at_peasland.com> wrote in message news:<3DD417A2.8BF03023_at_peasland.com>...
> > I can't agree 100% with Daniel, it will *reduce* the instances of lost
> > numbers but the INSERT INTO error_log may also get rolled back or fail
> > under some circumstances.
>
> True, and CURRVAL will not work unless NEXTVAL has already been selected
> in that session. Otherwise, one will get the ORA-8002 error.
>
> HTH,
> Brian

I've just had an article published in dbazine.com (it appeared yesterday). It touches on the internals of sequences in DB2 and Oracle and SQL Server. "Sequences and Identity Columns": http://dbazine.com/gulutzan4.html.

Peter Gulutzan Received on Fri Nov 15 2002 - 18:35:32 CST