Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

why AUTOCOMMIT still ON on Delete ?

764712Aug 15 2011 — edited Aug 17 2011
Hi,
is AUTOCOMMIT=FALSE, workd differently on Insert and Delete ? I'm on 10gXE and SQL Developer
I can't understand why I have situation like below:

Tx
T
create table  tt (c1 int,  c2 char2(200));
alter session set AUTOCOMMIT=FALSE;
insert   into  tt values (s1.nextval, 'XXXXXXXXXX');
insert   into  tt values (s1.nextval, 'XXXXXXXXXX');
insert   into  tt values (s1.nextval, 'XXXXXXXXXX');
select COUNT(*) from tt;  = 0
commit;       -------- AUTOCOMMIT STILL FALSE
select COUNT(*) from tt;  = 3
delete from tt; 
-- 3 Row(s) affected  
select COUNT(*) from tt;  = 0  --------- why ? ????  expect it =3, AUTOCOMMIT still set =FALSE
This post has been answered by sb92075 on Aug 15 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2011
Added on Aug 15 2011
11 comments
2,686 views