Use implicit or explicit cursor to insert 50000 rows to a table : Implicit Cursor « Cursor « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Cursor
3. Implicit Cursor

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.