Re: Oracle Serial numbers

huele_at_pacbell.net wrote:
>
> I want to have serial number on my table record by using "nextval", but
> the number go from 1,2,3,4,5 then 21,21,24,25. Any expert can help me
> out?
> Thanks alot.

I'm no expert, but fortunately I have the experience.

In multi-user environment, different user can obtain the sequence no. and
increment it. However, they may not be using it, since the transaction can
failed and rollbacked.

Also, It can be other reasons too. Received on Fri Oct 04 1996 - 00:00:00 CEST