@Akshay，
请找到下面的代码以供参考。
Create or replace procedure create_cursor isl_statement varchar2(32767);cursor v_records is select * from t;beginfor temp in v_recordsloop l_statement := 'INSERT INTO myTable (id, name) select '||temp.id||',' ||temp.name|| ' from ' || temp.table1 || ' where ' || temp.where_clause; execute immediate l_statement; end loop;end;/
