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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How get the current value from a sequence?

Re: How get the current value from a sequence?

From: AK <ak_tiredofspam_at_yahoo.com>
Date: 30 Nov 2004 19:14:52 -0800
Message-ID: <46e627da.0411301914.5bbe9e5@posting.google.com>


> > 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

Original text of this message

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