动态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;