What happens If we exit out of a session without committing an update statement in sqlplus. Can we commit it after logging into the session again?
-
2No, not possible depends on your lost individual session.Barbaros Özhan– Barbaros Özhan2019-01-29 12:44:45 +00:00Commented Jan 29, 2019 at 12:44
-
1This question has all the details you need.ShellDragon– ShellDragon2019-01-29 12:48:31 +00:00Commented Jan 29, 2019 at 12:48
Add a comment
|
1 Answer
Exit automatically issues a commit statement before leaving the sqlplus.
1 Comment
ShellDragon
Additionally, exit behavior can be configured with
SET EXITC[OMMIT] {ON | OFF} if you're running 11g or higher. Reference