to find last number generated for sequence object

[tamilselvan]

Use SEQUENCE_NAME.CURRVAL.
SQL> select tamil_seq.nextval from dual;

NEXTVAL
----------
2

SQL> select tamil_seq.currval from dual;

CURRVAL
----------
2

CURRVAL will work only after you executed nextval, oherwise you will get an error:

SQL> select tamil_seq.currval from dual;
select tamil_seq.currval from dual
*
ERROR at line 1:
ORA-08002: sequence TAMIL_SEQ.CURRVAL is not yet defined in this session


Tamil