How to get a sequence value

[dsrinivas]

Hi,

Select seq_name.CURRVAL from dual;

If you are querying for the first time after creation of the sequence then issue like this

Select seq_name.NEXTVAL from dual;

then you can use

Select seq_name.CURRVAL from dual;

Thanks

Srinvias