create procedure pro(p_table in varchar2,p_seq in varchar2,p_main_col in varchar2)
as
str varchar2(100);
begin
str:='begin '||
'insert into '||p_table||' ('||p_main||') select '||p_seq||'.nextval from dual; end;';
execute immediate str;
end;
/
as
str varchar2(100);
begin
str:='begin '||
'insert into '||p_table||' ('||p_main||') select '||p_seq||'.nextval from dual; end;';
execute immediate str;
end;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货