大家好,现在有个需求,有多张表需要数据更新操作。我想写个模板SP,将表名做为参数批量更新,但是在数据插入时,表名作为参数运行:v_sql := 'insert into :1(val,tdate,tid,workdate) select val,tdate,tid,workdate from tmp_hyin_tgt
';
execute immediate v_sql using tabname;但是程序运行报错:表名无效,请问如何解决? 谢谢!
';
execute immediate v_sql using tabname;但是程序运行报错:表名无效,请问如何解决? 谢谢!
table_name := 'table1';
v_sql := 'insert into '||table_name||'(val,tdate,tid,workdate) select val,tdate,tid,workdate from tmp_hyin_tgt';
execute immediate v_sql using tabname;
execute immediate v_sql;