Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View current seq. no.
Shriley,
then you should define what you identify as "current value".
LAST_NUMBER would give you the DB wide last sequence number fetched, while sequence.curval would give you the current sequence number of your session.
The difference is important and it depends what you are trying to accomplish.
Imagine having cache 10, user A fetches, user B fetches for user A it might be 1, for B it might be 11, but the DB can only guarantee that 20 was the last fetched ... if B uses all 10 sequences or not.
The real USED last sequence can only be derived from the target you stored the sequence into.
Regards
Dante
In article <eZHYaFCm#GA.154_at_pet.hiwaay.net>,
"Shirley Kwan" <sskwan_at_ingr.com> wrote:
> LAST_NUMBER shows the current value only if no cache is used !!!
>
> Prabhakar Narayanan wrote in message <37312F01.755CC94E_at_clsasia.com>...
> >Hi
> >
> >You can access USER_SEQUENCES table
> >
> >SELECT SEQUENCE_NAME, LAST_NUMBER
> >FROM USER_SEQUENCES
> >
> >This should give you the desired result
> >
> >Regards
> >
> >N.Prabhakar
> >
> >
> >Shirley Kwan wrote:
> >
> >> Hi,
> >>
> >> Does anyone know that how to view all current value of all sequences
> without
> >> changing the value ???
> >>
> >> Thanks in advance !!!
> >>
> >> Shirley......
> >
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri May 07 1999 - 13:47:13 CDT