Re: Sequence without holes

From: marc parkinson <marcpark_at_starband.net>
Date: Fri, 18 Oct 2002 02:19:14 GMT
Message-ID: <YcKr9.5061$Kc.2387072089@twister1.starband.net>

In answer to question 1,
Sorry you can't do that. Once Oracle assigns a sequence number it is gone. That is the way they work.

Marc Parkinson

"P B" <pbeliveau_at_avcorp.com> wrote in message news:1j5uqu4r412rcqfjg4d978mhhal5qkimmc_at_4ax.com...
> Question #1
>
> I would like to have a sequence but as I understand it, if for some
> reason a user make a rollback or what so ever, I loose his sequence
> number.
>
> I don't want that. I want a sequence that has no hole, so if a user
> make a rollback, the next user that request a number would receive the
> number that was rolled back.
>
> Question #2
>
> How do I lock a row that does not exist? I did not yet insert the row
> but I will soon and I don't want other user to use my key. I dont want
> to lock the whole table because I'm not the only who use it.
Received on Thu Oct 17 2002 - 21:19:14 CDT