Skip to Main Content
Forums

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!

Rollback in Sequence object

848959Mar 21 2011 — edited Aug 2 2012
Hi,

In a procedure, we insert 5 records by retrieving data from Sequence object,
when we issue Rollback now, what will be the outcome, will the sequence object goes back by 5 numbers
or we lost 5 sequence numbers.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2012
Added on Mar 21 2011
#oracle, #transaction
8 comments
4,949 views