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......
>
Received on Thu May 06 1999 - 19:37:02 CDT
