Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How do you retrive the CURRVAL of the sequence from a servlet?

Re: How do you retrive the CURRVAL of the sequence from a servlet?

From: Yi Jin <yijin_at_wam.umd.edu>
Date: 2000/05/04
Message-ID: <8esht1$4jf@rac3.wam.umd.edu>#1/1

Where is that currval (or nextval) is stored in the system tables?

I tried:
  select last_number from user_sequences;

However, that 'last_number" does not change as I inserted many records using nextval.

YJ Received on Thu May 04 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US