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;
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;