2017  Kodetalk | Feedback | Privacy Policy | Terms | About
userimage

Rollback after sequence.nextval

If i have write sequence.next value for more than 10 times and i click rollback.

Will the sequence will be reset to 10 time back fromcurrent position.

userimage

No.

It will not go to the back positions once you fired rollback.

It will continue from same position like below.

select abc.nextval from duel;

o/p: 1

select abc.nextval from duel;

o/p: 2

select abc.currval from duel;

o/p: 2

rollback;

select abc.nextval from duel;

o/p : 3

Answer is