Re: Turning off DML commit when session is exited or disconnected
From: Jeremy <jeremy0505_at_gmail.com>
Date: Thu, 18 Dec 2008 14:22:12 -0000
Message-ID: <MPG.23b46ceabee2210c9896ae@News.Individual.NET>
Date: Thu, 18 Dec 2008 14:22:12 -0000
Message-ID: <MPG.23b46ceabee2210c9896ae@News.Individual.NET>
In article <619d22a2-cb7a-4d1d-a889-11e4a9014d58
@r36g2000prf.googlegroups.com>, rcllnx_at_gmail.com says...>
> If i issue a DML statment in oracle database from sqlplus session
> (where autocommit is off by default ) and then 'exit' or 'disc' the
> session without explicitly commiting the DML ,the DML gets commited .
> Is it possible to turn off this default behaviour.
> Thanks in Advance
in sqlplus:
SQL> set autocommit off
?
-- jeremyReceived on Thu Dec 18 2008 - 08:22:12 CST