savepoint的使用

create table AA
(
  id   NUMBER,
  name VARCHAR2(3)
);
insert into aa (id,name) values(1,‘g1‘);

insert into aa (id,name) values(2,‘g2‘);

select t.*, t.rowid from AA t;


commit;
--------------
insert into aa (id,name) values(3,‘g3‘);

rollback;

insert into aa (id,name) values (4, ‘g4‘);
insert into aa (id,name) values (5, ‘g5‘);
savepoint A;
update aa set name=‘g9‘ where id=5;

update aa set name=‘g10‘ where id=5;
update aa set name=‘g11‘ where id=6;

savepoint B;

insert into aa (id,name) values (6, ‘g6‘);
 rollback to B;
 rollback to A;
 commit;  --或者 rollback;