Originally posted by s_modem
Again I am creating the same Sequence

CREATE SEQUENCE TEST_SEQ INCREMENT BY 1 START WITH 1 MAXVALUE 25 MINVALUE 1

SELECT TEST_SEQ.CURRVAL FROM DUAL;
CURRVAL
-----------
20
At this point the value TEST_SEQ.CURRVAL is NOT yet defined. How did you get oracle to return a value to you??????

-amar