Mega Code Archive
Use implicit or explicit cursor to insert 50000 rows to a table
<![CDATA[
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.
]]>