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