Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

Nested WHILE Loop

SQL> SQL> declare   2      v_ind     NUMBER;   3      v_current NUMBER;   4  begin   5      v_current:=0;   6      while v_current<=25   7      loop   8          v_ind:=0;   9          while v_ind<4  10          loop  11              v_ind:= v_ind+1;  12              DBMS_OUTPUT.put_line(v_current);  13          end loop;  14          v_current:=v_current+5;  15      end loop;  16  end;  17  / 0 5 10 15 20 25 PL/SQL procedure successfully completed. SQL>