Re: sql*plus autocommit and exit
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: dba.orcl@xxxxxxxxx
- Date: Mon, 15 Aug 2005 15:36:22 -0400
Sami Seerangan wrote:
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?
Yes. Autocommit commits after each statement.
--
Mladen Gogala
Oracle DBA
Ext. 121
--
http://www.freelists.org/webpage/oracle-l
- References:
- sql*plus autocommit and exit
- From: Sami Seerangan
Other related posts:
- » sql*plus autocommit and exit
- » RE: sql*plus autocommit and exit
- » Re: sql*plus autocommit and exit
- » RE: sql*plus autocommit and exit
- » Re: sql*plus autocommit and exit
- » RE: sql*plus autocommit and exit
- » RE: sql*plus autocommit and exit
- » RE: sql*plus autocommit and exit
- » Re: sql*plus autocommit and exit
- » Re: 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?
Yes. Autocommit commits after each statement.
-- http://www.freelists.org/webpage/oracle-l
- sql*plus autocommit and exit
- From: Sami Seerangan