Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Missing sequences... how to retrieve the missing no?

Re: Missing sequences... how to retrieve the missing no?

From: Gennaro Napolitano <Gennaro.Napolitano_at_italdata.it>
Date: 2000/05/10
Message-ID: <39190A44.2C2FA60C@italdata.it>#1/1

Hello

I think that using "select max(id) +1 from table" still does not guarantee contiguous
values for a column, furthermore you can generate duplicate values.

Ciao Gennaro

Mike Dwyer wrote:

> This should be in a FAQ.
>
> What you are asking to do should not be done with a sequence. Use select
> max(id) +1 from table. You really cannot guarantee contiguous
> (uninterrupted) values from a sequence.
Received on Wed May 10 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US