create or replace procedure ( tbl1 varchar2,tbl2 varchar2)
isbegin
execute immediate 'insert into '||tbl1 ||' select * from '||tbl2;
end;
isbegin
execute immediate 'insert into '||tbl1 ||' select * from '||tbl2;
end;
否则用 DBMS_SQL 帮忙,就搞定了