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!

Question about CURRVAL and NEXTVAL?

User_TDDEPJun 28 2015 — edited Jun 29 2015

Why values from seq.currvalAND seq.nextval have this same value in:

select seq.currval, seq.nextval from dual;



Could someone answer my simple question?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2015
Added on Jun 28 2015
7 comments
34,053 views