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!

Future Update Request - Show Number of Rows Affected After 'ROLLBACK/COMMIT' Executes

RedWhiteNBlueFeb 23 2020 — edited Feb 28 2020

I would like the Oracle Database to report the number of rows affected once a ROLLBACK/COMMIT statement occurs. This would be very consistent with the reporting of other statements that get executed and be very helpful to the end-user.

And since it's possible that everybody may not want this feature all the time it could be updated as optional display of output, for instance: ROLLBACK ..... [WITH DETAILS]; or maybe COMMIT [DETAILS | VERBOSE]. Something along those lines.

Comments
Post Details
Added on Feb 23 2020
9 comments
1,530 views