Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How get the current value from a sequence?
> > I don't want to gaps in the sequence.
>
> Then use a method that serializes on a table.
> Sequences guarantee uniqueness not completeness.
I'd concur. For instance, Oracle comes with built in message queueing, which comes very handy when you don't want gaps.
But what is wrong with having gaps in your situation? Received on Tue Nov 30 2004 - 21:14:52 CST
![]() |
![]() |