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

Home -> Community -> Usenet -> c.d.o.server -> Re: reading sequence.CURRVAL

Re: reading sequence.CURRVAL

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Fri, 24 Apr 1998 16:26:35 GMT
Message-ID: <6hqefo$bis@bgtnsc03.worldnet.att.net>


On Thu, 23 Apr 1998 12:43:31 -0700, Bill Dietrich <bill_dietrich_at_wayfarer.com> wrote:

>What I'd like to do is just read sequence.CURRVAL, where
>this is a sequence that generates record IDs for the table. If CURRVAL
>has
>increased since the last time I read it, I know there are new records,
>and what range their IDs are in.

I'm not sure that you can always count on this. We sometimes get gaps. I think that in the event of a crash that you will lose the sequences that Oracle has cached. Received on Fri Apr 24 1998 - 11:26:35 CDT

Original text of this message

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