Select value into a number variable in a for loop
SQL>
SQL> create table myTable(
2 x number,
3 y char(100)
4 );
Table created.
SQL>
SQL> insert into myTable
2 select rownum, 'padding'
3 from all_objects
4 where rownum < 10001;
10000 rows 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
6 into dummy
7 from myTable
8 where x = 1;
9 end loop;
10 end;
11 /
Procedure created.
SQL>
SQL>
SQL>
SQL>
SQL> drop table myTable;
Table dropped.
Related examples in the same category