Sql Code:
>create table product
(pcode number(2),
pname varchar2(10));
>insert into product values(1,'pencil');
>insert into product values(2,'pencil');
>savepoint a;
>update product set pcode=10 where pcode=1;
>savepoint b;
>delete from product where pcode=2;
>commit;
>delete from product where pcode=10;
>rollback to savepoint a;
>select * from product;
Oracle 9i result;
This is different.
Oracle 11g result;
No sql statement rollbacked.The rollback generates an error.
Hiç yorum yok:
Yorum Gönder