User_Sequence's LAST_NUMBER column: what is it?

From: Jerry Liu <taora2000_at_yahoo.com>
Date: 10 Oct 2001 19:02:20 -0700
Message-ID: <1b78c562.0110101802.2b2cc970@posting.google.com>

Would someone know what the "LAST_NUMBER" column of the user_sequences dictionary table contains? It does not seem to be related to the "NEXTVAL" or "CURRVAL" (see below)

---

SQL> ed
Wrote file afiedt.buf

  1 select SEQUENCE_NAME, min_value, max_value, last_number   2* from user_sequences where sequence_name = 'MY_SEQ_20011010' SQL> /

SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE LAST_NUMBER
------------------------------ ---------- ---------- -----------
MY_SEQ_20011010                         1 1.0000E+27          21

SQL> select MY_SEQ_20011010.nextval, MY_SEQ_20011010.currval from dual;

   NEXTVAL CURRVAL
---------- ----------

         8 8

---

Thanks,

Jerry Received on Wed Oct 10 2001 - 21:02:20 CDT