problem about Sequence
From: Ken Ho Kwok Fai <kfho_at_cse.cuhk.edu.hk>
Date: 28 Oct 1998 13:31:03 GMT
Message-ID: <7176an$5kg_at_eng-ser1.erg.cuhk.edu.hk>
[Quoted] create table registration
(user_id number NOT NULL primary key,
user_name varchar2(11)
);
Date: 28 Oct 1998 13:31:03 GMT
Message-ID: <7176an$5kg_at_eng-ser1.erg.cuhk.edu.hk>
[Quoted] I made a sequence in a table "test" by the following SQL:
[Quoted] create table registration
(user_id number NOT NULL primary key,
user_name varchar2(11)
);
[Quoted] 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 HoReceived on Wed Oct 28 1998 - 14:31:03 CET