不用存储过程，直接INSERT就行
insert into D
(select * from A where
mz not in(select mz from B) and
jg not in(select jg from C));
你要存储过程的话再加个壳
create or replace procedure XXX
IS
begin
insert into D
(select * from A where
mz not in(select mz from B) and
jg not in(select jg from C));
end;
/
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024