Re: foocounter.CURRVAL

Hi!

currval contains the last generated number in the current session.

I have tried the following:

Started two SQLPlus sessions:

performing this select in Session 1:

select setest.nextval
from dual;

giving 2

Select setest.currval
from dual;
giving 2

performing this in Session 2:
select setest.nextval
from dual;

giving 3

Performing
Select setest.currval
from dual;

giving 3

In Session 1
performing:

Select setest.currval
from dual;

still giving 2

Frank Received on Fri Mar 16 2001 - 12:36:13 CST