|
SQL>
SQL> declare
2 v_ind NUMBER;
3 v_current NUMBER;
4 v_max_printed NUMBER :=10;
5 v_printed NUMBER:=0;
6 begin
7 v_current:=0; -- should not be null!
8 <<Main>>
9 loop
10 v_ind:=0; -- reset each time
11 <<Inner>>
12 loop
13 v_ind:=v_ind+1;
14 DBMS_OUTPUT.put_line(v_current);
15 v_printed:=v_printed+1;
16 exit Main when v_printed = v_max_printed;
17 exit when v_ind=4;
18 end loop Inner;
19 v_current:=v_current+5;
20 exit when v_current=25;
21 end loop Main;
22 end;
23 /
0
0
0
0
5
5
5
5
10
10
PL/SQL procedure successfully completed.
SQL>
SQL>
|