Go to the FreeLists Home Page Home Signup Help Login 		 



Browse oracle-l: This Month's Archive • Main Archive Page • Related posts • Previous by Date • Next by Date

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

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




    • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.