create or replace procedure zhuancunis is
p_cnt number;
begin
select count(1) into p_cnt from test2;
if p_cnt > 0 then
delete from test2;
end if;
select count(1) into p_cnt from test4;
if p_cnt > 0 then
delete from test4;
end if;
insert into test2
select * from test1;
insert into test4
select * from test3;
commit;
end;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024