存储过程里面可以不可以是一些delete语句?---1.创建一个自定义过程
reate or replace procedure resch as
begin
delete from res_ge1 where a = 2;
delete from res_ge2 where b = 3;
delete from res_ge3 where c = d;
end;
/
reate or replace procedure resch as
begin
delete from res_ge1 where a = 2;
delete from res_ge2 where b = 3;
delete from res_ge3 where c = d;
end;
/
并且你可以指定事务commit
如:
---1.创建一个自定义过程
reate or replace procedure resch as
begin
delete from res_ge1 where a = 2;
commit;
delete from res_ge2 where b = 3;
commit;
delete from res_ge3 where c = d;
commit;
end;
/