Re: View current seq. no.

Yes, it's correct.
So it means that we don't have a way to review the current value of the sequence unless the cache size is zero !!!

Shirley......

Dante wrote in message <7gvcff$ntn$1_at_nnrp1.deja.com>...
>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 Sun May 09 1999 - 19:51:39 CDT