create or replace procedure test (p_tab in varchar2) as begin execute immediate 'insert into '||p_tab||' values(......)'; end; /
怎么执行总出错呢 看我写的对不 create or replace procedure TEST2(tab in varchar2,mid in varchar2,mname in varchar2,age in number) as begin execute immediate 'insert into '||tab||' values(mid,mname,age)'; end TEST2;
create or replace procedure TEST2(tab in varchar2,mid in varchar2,mname in varchar2,age in number) as begin execute immediate 'insert into '||tab||' values('||mid||','||mname||','||age||')'; end TEST2;
如果mid、mname、age有可能为空的话,用下面的好点 create or replace procedure TEST2(tab in varchar2,mid in varchar2,mname in varchar2,age in number) as begin execute immediate 'insert into '||tab||' values('||''''||mid||''''||','||''''||mname||''''||','||''''||age||''''||')'; end TEST2;
as
begin
execute immediate 'insert into '||p_tab||' values(......)';
end;
/
怎么执行总出错呢
看我写的对不
create or replace procedure TEST2(tab in varchar2,mid in varchar2,mname in varchar2,age in number)
as
begin
execute immediate 'insert into '||tab||' values(mid,mname,age)';
end TEST2;
as
begin
execute immediate 'insert into '||tab||' values('||mid||','||mname||','||age||')';
end TEST2;
create or replace procedure TEST2(tab in varchar2,mid in varchar2,mname in varchar2,age in number)
as
begin
execute immediate 'insert into '||tab||' values('||''''||mid||''''||','||''''||mname||''''||','||''''||age||''''||')';
end TEST2;