Oracle 事务

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;

  

原文地址:https://www.cnblogs.com/wdw31210/p/5623989.html