Re: problem about Sequence

Hi, Ken,

If what you want to know is what the last value the sequence generated, then use:
select last_number from user_sequence;

But remember, the maximum value for the table may be less than the last_number value, since a number generated by a sequence can be 'discarded' if the update or insert into your table was not committed.

[Quoted] Hope this helps.

Gene Plagge
WorldxChange, Inc.
gplagge_at_hotmail.com

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 Thu Oct 29 1998 - 23:27:33 CET