Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

Exiting from Nested Loops

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 5 10 PL/SQL procedure successfully completed. SQL>