博客园站长
这是人类成长进步中记录的每一时刻
begin
begin
savepoint p1;

DELETE FROM sys_re_xxx;  //红色部分替换为需要一起执行的SQL即可

DELETE FROM SYS_xxxx;

......

exception
when others then
begin
rollback to savepoint p1;

return;
end;
end;
commit;

end;

  

posted on 2016-06-28 16:33  dm3344  阅读(155)  评论(0)    收藏  举报