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

Try
SELECT sequence_name.CURRVALFROM DUAL
or
SELECT sequence_name.NEXTVAL FROM DUAL

Yi Jin <yijin_at_wam.umd.edu> wrote in message news:8esht1$4jf_at_rac3.wam.umd.edu...
>
> 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