Re: View current seq. no.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 11 May 1999 21:23:30 +0100
Message-ID: <926454667.2733.1.nnrp-02.9e984b29@news.demon.co.uk>

There is an unpublished v$ object owned by SYS which has the necessary information.

Look at sys.v$_sequences

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

>> >> >Shirley Kwan wrote:
>> >> >
>> >> >> Hi,
>> >> >>
>> >> >> Does anyone know that how to view all current value of all
>sequences
>> >> without
>> >> >> changing the value ???
>> >> >>
Received on Tue May 11 1999 - 15:23:30 CDT