problem about Sequence

From: Ken Ho Kwok Fai <kfho_at_cse.cuhk.edu.hk>
Date: 28 Oct 1998 13:30:41 GMT
Message-ID: <7176a1$5kg@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 - 07:30:41 CST