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!

When does exiting Sqlplus not commit an insert statement?

677527Dec 29 2008 — edited Dec 29 2008
Hi Folks,

Has anyone come across a scenario where following an insert statement, you log out of sqlplus without an explicit commit statement, and then find that the inserted data was not committed? Contrary, to general consensus, which is that exiting sqlplus automatically commits data, it would seem that there might be a way to set up your environment so that exiting sqlplus does not automatically commit your data. Is this true?

TIA,

Efachim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2009
Added on Dec 29 2008
3 comments
2,791 views