Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reading sequence.CURRVAL
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