第1个回答 推荐于2016-07-01
不用存储过程,直接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;
/本回答被提问者采纳