Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sql*plus Auto-Commit

Re: Sql*plus Auto-Commit

From: jerry <jdufour_at_finaplex.com>
Date: 28 Oct 2006 01:20:17 -0700
Message-ID: <1162023617.271683.16120@i3g2000cwc.googlegroups.com> 





Create a login.sql file if you do not already have one and add the line



set autocommit off



I suggest you read the SQL*PLUS Users Guide for further details re. the
location of the file.



Jerry



klabu wrote:


> I exited SQL*plus with commit/rollback and my transaction was coimmitted.

>

> How can I disable this auto-commit behavior ?

> 

> thanks

> 

> -- 

> 10gR2

Received on Sat Oct 28 2006 - 03:20:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US