|
SQL> create table myTable (x primary key) organization index as select 1 from dual;
Table created.
SQL>
SQL>
SQL> create or replace procedure implicit is
2 dummy number;
3 begin
4 for i in 1 .. 500 loop
5 select 1 into dummy from myTable;
6 end loop;
7 end;
8 /
Procedure created.
SQL>
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
|