RE: sql*plus autocommit and exit

I believe the ';exit' command issues a commit; quit issues rollback.
 
However, I cannot find this in the docs.
 

----------------- 
Ron Reidy 
Lead DBA 
Array BioPharma, Inc. 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Sami Seerangan
Sent: Monday, August 15, 2005 12:33 PM
To: oracle-l
Subject: sql*plus autocommit and exit


Hi:

I have a autocommit value set to OFF however when I exit from SQL*Plus it 
commits the transaction.
Is it a expected behavior?

SQL> show auto
autocommit OFF

SQL> delete from t1;
48601 rows deleted.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 
Production
With the Partitioning, OLAP and Data Mining options
C:\Documents and Settings\s397131\Desktop>sqlplus sami/sami
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 15 14:29:05 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from t1;

  COUNT(*)
----------
         0

SQL> show auto
autocommit OFF
SQL> 

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Other related posts: