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!

Can we make an Insert statement as Auto rollback

User_290VSJun 7 2021

Hi,
Is it possible to make an Insert statement auto rollback in oracle i.e., when one of the users issue an insert statement, it should execute normally, but immediately it should roll back the insert from back end. Is it possible to do so?
The user will NOT commit immediately after the insert.

Comments
Post Details
Added on Jun 7 2021
10 comments
1,250 views