declare my_data table_name%rowtype; my_num number;begin select col1,col2 into my_data from table_name t where col_name = '110101201605165'; for my_num in 1..10000000 loop insert into table_name t (t.col1,t.col2) values (my_num, my_data.col2); if mod(my_num,10000) = 0 then commit; end if; end loop; commit;end;精简许多，感觉还可以
转载于:https://www.cnblogs.com/iyoume2008/p/7649057.html
相关资源：测试数据生成脚本