Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

knowing the 2 previous values of sequence

636387Aug 24 2009 — edited Aug 24 2009
Hi

I have sequence with the name seq;
create sequence seq;

select seq.nextval from dual;

select seq.currval from dual;
 
select seq.nextval from dual;
Now i want to know the 2 previous values of sequence

Output is:
2
1

Please help me in this issue........

Thanks and Regards
SKPR
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2009
Added on Aug 24 2009
25 comments
1,520 views