Use implicit or explicit cursor to insert 50000 rows to a table
SQL> create table myTable ( x primary key ) 2 organization index as select 1 from dual; Table created. SQL> create or replace procedure implicit is 2 dummy number; 3 begin 4 for i in 1 .. 50000 loop 5 select 1 into dummy from myTable; 6 end loop; 7 end; 8 / Procedure created. SQL> create or replace procedure explicit is 2 cursor explicit_cur is select 1 from myTable; 3 dummy number; 4 begin 5 for i in 1 .. 50000 loop 6 open explicit_cur; 7 fetch explicit_cur into dummy; 8 close explicit_cur; 9 end loop; 10 end; 11 / Procedure created. SQL> SQL> drop table myTable; Table dropped.