Question

oracle 中怎么写循环插入数据脚本

Answer 1

declare
v_sql varchar2(4000);
begin
for i in 1..10000 loop
v_sql:='insert into table(col1) values('||i||');
execute immediate(v_sql);
end loop;
end;