OraFAQ Forum: SQL & PL/SQL » DML written on a script autocommits after a DDL in the same script without any commit statements?

Home » SQL & PL/SQL » SQL & PL/SQL » DML written on a script autocommits after a DDL in the same script without any commit statements? (oracle,10g,xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DML written on a script autocommits after a DDL in the same script without any commit statements? [message #605058]

Tue, 07 January 2014 04:11

evivek
Messages: 6
Registered: December 2013
Location: mumbai

Junior Member

Hi i have written a script
------------------------------
create table test1(id number);
create table test2(id number);
-------------------------------

then written a script
-------------------------------
insert into test1 values(1);

alter table test2 add val varchar2(20);

insert into test1 values(2);

---------------------------------------

i had open two session of sqlplus
in the first one i run th eabove scrpt
and without commit

when i check in the scond session test1 table have the entry 1 but not 2

why running any ddl auto commit the dml statement excuted previously in that session ????????

Report message to a moderator