create or replace procedure(vi_fromkey integer, vi_tokey integer) as
begin
insert into xyz (xyz1, xyz2) select vi_tokey, xyz2 from xyz where xyz = vi_fromkey;
insert into abc (xyz1, abc1, abc2) select vi_tokey, abc1, abc2 from abc where xyz = vi_fromkey;
end;
1 回答
您只需要两个insert select语句: