commit and rollback in sqlplus session
599269Aug 15 2009 — edited Aug 16 2009Hi All,
I have observed that whenever i do exit after an uncommited transaction say ( insert or update or delete ) statement , sqlplus commits by its on .
Why its so ?? is it a configuration in oracle ??
How can we control this behaviour ??
Eg :
$ sqlplus scott/tiger@orcl
SQL> sho autocommit
autocommit OFF
SQL>select * from foo;
A B
---------- -------
100 200
200 300
SQL>insert into foo values ( 300,200) ;
1 row created.
SQL>exit;
$ sqlplus scott/tiger@orcl
SQL > select * from x ;
A B
---------- -------
100 200
200 300
300 200
From above example :
auto commit is off . But still when session ends , its commits . Please explain .
DB : 10gR2
Thanks in Advance .