本文介绍了在Oracle中如何使用动态SQL插入数据，并通过绑定变量的方式避免了大量的DML语句导致的性能问题。示例代码展示了如何在循环中使用绑定变量`using`子句进行数据插入，这种方式可以有效防止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;
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;
扫一扫
147
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
