动态SQL使用绑定变量

SQL> begin
  for i in 1..1000000 
  loop
    execute immediate 'insert into p1 values(i)' ;
    commit;
  end loop;
end;  2    3    4    5    6    7  
  8  /
begin
*
ERROR at line 1:
ORA-00984: column not allowed here
ORA-06512: at line 4




begin
  for i in 1..1000
  loop
    execute immediate 'insert into p1 values(:x)' using i;
    commit;
  end loop;
end;