Re: Sequence CURRVAL & NEXTVAL

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: 12 Aug 2004 08:38:29 -0700
Message-ID: <d4d6f278.0408120738.688ae952@posting.google.com>

Sequences are "just" a way of having the system provide an artificial key - no more no less.

You will (at least) always lose some sequence values on those rare times when an instance has to be brought down and backup based on what the CACHE value is set to.

Application logic should not be sensitive to whether there are missing values in the sequences ... again it's an artificial key that's it.

If there is something in the real world that makes it important to a business process or computer application to track things sequentially and never lose any values -- you don't want to be using sequences. Received on Thu Aug 12 2004 - 10:38:29 CDT