Re: problem about Sequence

Hi
take a look at he user_sequences view , wou will find the last_number column which indicates what you want..
Hope it will help you!

Vincent Roquencourt,
DBA at Business Objects, France

Ken Ho Kwok Fai wrote in message <7176an$5kg_at_eng-ser1.erg.cuhk.edu.hk>...
> I made a sequence in a table "test" by the following SQL:
>
>============================================================
>create table registration
> (user_id number NOT NULL primary key,
> user_name varchar2(11)
> );
>
>create sequence user_id_seq start with 1 increment by 1 nocycle;
>=============================================================
>
> After I insert some values to the table, how could I know the
>max sequence number? Is there a table to store the sequence? I don't want
>to select it from the table and the compare the largest number as it
>needs a lot of time. Any method that could allow me to get the max
>sequence number? Thanks a lot.
>
>--
>Regards,
>Ken Ho
Received on Wed Oct 28 1998 - 15:22:09 CET