View Single Post

   
  #3 (permalink)  
Old 02-24-2008, 08:41 AM
Michel Cadot
 
Posts: n/a
Default Re: Flag controlling the 'automatic commit' mode??


"qazmlp" <qazmlp1209@rediffmail.com> a écrit dans le message de
news:db9bbf31.0411030852.998d69b@posting.google.co m...
> If I come out of the SQL prompt after performing some DML statements
> and without doing commit, I find that the automatic commit has been
> done for those statements. I would like to know what exactly is the
> flag that controls this. I want to set that flag accordingly such
> that, the transactions are not automatically committed whenever the
> user comes out of the SQL prompt.
>
> Thanks!


Have a look at "set autocommit" statement:
http://download-west.oracle.com/docs...13.htm#1012156

--
Regards
Michel Cadot


Reply With Quote