set exitcommit on causes SQL*Plus to commit the current transaction when an SQL*Plus session is terminated with the exit command.
set exitcommit off causes it to be rolled back.
set exitcommit off
set exitcommit off
drop table tq84_exitcommit purge;
create table tq84_exitcommit (a number);
insert into tq84_exitcommit values (1);
insert into tq84_exitcommit values (2);
commit;
insert into tq84_exitcommit values (3);
insert into tq84_exitcommit values (4);
exit
set exitcommit on
drop table tq84_exitcommit purge;
create table tq84_exitcommit (a number);
insert into tq84_exitcommit values (1);
insert into tq84_exitcommit values (2);
commit;
insert into tq84_exitcommit values (3);
insert into tq84_exitcommit values (4);
exit