Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: taora2000@yahoo.com (Jerry Liu)
Newsgroups: comp.databases.oracle.server
Subject: User_Sequence's LAST_NUMBER column: what is it?
Date: 10 Oct 2001 19:02:20 -0700
Organization: http://groups.google.com/
Lines: 25
Message-ID: <1b78c562.0110101802.2b2cc970@posting.google.com>
NNTP-Posting-Host: 207.208.246.194
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002765740 19142 127.0.0.1 (11 Oct 2001 02:02:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 11 Oct 2001 02:02:20 GMT
Xref: easynews comp.databases.oracle.server:120888
X-Received-Date: Wed, 10 Oct 2001 20:00:02 MST (news.easynews.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