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?
On Thu, 2 Dec 2004 20:22:28 +0000 (UTC), weberm_at_polaris.net
(Ubiquitous) wrote:
>AK <ak_tiredofspam_at_yahoo.com> wrote:
>
>:> > 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?
>
>One word. Auditors.
>
>
One response: Then don't use sequences.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Dec 02 2004 - 15:11:52 CST