Re: Flag controlling the 'automatic commit' mode??

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 3 Nov 2004 19:12:03 +0100
Message-ID: <41891ed7$0$32145$636a15ce@news.free.fr>

"qazmlp" <qazmlp1209_at_rediffmail.com> a écrit dans le message de news:db9bbf31.0411030852.998d69b_at_posting.google.com...
> 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/cd/B10501_01/server.920/a90842/ch13.htm#1012156

-- 
Regards
Michel Cadot

Received on Wed Nov 03 2004 - 12:12:03 CST