Re: uncomitted data gets committed when application dies

Sqlplus does not do it.

SQL> create table foo (n_ number);

Table created.

SQL> insert into foo values (1);

1 row created.

SQL> select * from foo;

N_

SQL> #### Not committed yet. Sqlplus session killed from task manager ####

C:\>sqlplus user/password_at_database

SQL*Plus: Release 9.2.0.5.0 - Production on Wed Dec 8 18:05:25 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.5.0 - Production
SQL> select * from foo;

no rows selected

SQL> Regards
/Rauf Received on Wed Dec 08 2004 - 12:12:26 CST