Re: Help on SQL

From: Steve Davis <spd_at_patrol.i-way.co.uk>
Date: Wed, 06 May 1998 17:52:37 GMT
Message-ID: <354f52b8.0_at_news.i-way.co.uk>


Beware of using a sequence if your values have to be sequential. Rolling back the transaction does NOT restore the sequence.

Steve

owrkrj_at_mailhub.sickkids.on.ca (Joost Ouwerkerk) wrote:

>The current value of the sequence is automatically incremented each
>time NEXTVAL is called for that sequence. Rolling back the
>transaction will restore the sequence.
Received on Wed May 06 1998 - 19:52:37 CEST

Original text of this message