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!

How to quit SQL*Plus without committing?

489554Jul 31 2007 — edited Jul 31 2007
Hi all,

I know that when you type QUIT or EXIT in a SQL*Plus session, it will automatically commit any changes. And if you just kill the application, then it does a rollback.

On one particular database, I'd like to set it so that anytime someone does a QUIT or EXIT in their SQL*Plus session, that it does a ROLLBACK, not a COMMIT. Is there a way to set this up so it is system-wide?

Thanks!
--Brad
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2007
Added on Jul 31 2007
8 comments
2,921 views