qazmlp wrote:
> 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.
>
Hello qazmlp,

Oracle always commits before and after a DML operation. I don't think
there is some flag to disable that.

Hope that helps,
Lothar

--
Lothar Armbrüster | la@oktagramm.de
Hauptstr. 26 | la@heptagramm.de
D-65346 Eltville | lothar.armbruester@t-online.de