--VALUES去掉看看
declare 
        v_sql varchar2(2000); 
begin 
  FOR i IN 1..3 LOOP  
  v_sql := ' insert into dtiajb2 select PRODUCE_DATE, 
' || i || ' 
from dtiajb'; 
  execute immediate v_sql; 
  commit; 
  END LOOP; 
end;