Using labels with loops : Label « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Label

Using labels with loops

  

SQL>
SQL> -- Using labels with loops.
SQL> BEGIN
  2        <<outerloop>>
  3        FOR i IN 1..2 LOOP
  4             <<innerloop>>
  5             FOR j IN 1..4 LOOP
  6                  DBMS_OUTPUT.PUT_LINE('Outer Loop counter is ' || i ||
  7                       ' Inner Loop counter is ' || j);
  8             END LOOP innerloop;
  9        END LOOP outerloop;
 10  END;
 11  /
Outer Loop counter is 1 Inner Loop counter is 1
Outer Loop counter is 1 Inner Loop counter is 2
Outer Loop counter is 1 Inner Loop counter is 3
Outer Loop counter is 1 Inner Loop counter is 4
Outer Loop counter is 2 Inner Loop counter is 1
Outer Loop counter is 2 Inner Loop counter is 2
Outer Loop counter is 2 Inner Loop counter is 3
Outer Loop counter is 2 Inner Loop counter is 4

PL/SQL procedure successfully completed.

SQL>
SQL>
           
         
    
  

Related examples in the same category