Oracle PL/SQL/PL SQL/Repeat Until

Demonstrating a REPEAT...UNTIL loop

SQL>
SQL> --Demonstrating a REPEAT...UNTIL loop.
SQL>
SQL>
SQL>
SQL> DECLARE
  2        r NUMBER := 2;
  3  BEGIN
  4        LOOP
  5            DBMS_OUTPUT.PUT_LINE("The Area is " || r * r * mypi);
  6             r := r + 2;
  7            EXIT WHEN r > 10;
  8        END LOOP;
  9  END;
 10  /
The Area is 12.56
The Area is 50.24
The Area is 113.04
The Area is 200.96
The Area is 314
PL/SQL procedure successfully completed.
SQL>

Loop exit when condition

SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2      counter INTEGER := 2;
  3  BEGIN
  4
  5    LOOP
  6       counter := counter + 1;
  7       DBMS_OUTPUT.PUT_LINE(counter);
  8    EXIT WHEN counter = 5;
  9
 10    END LOOP;
 11
 12  END;
 13  /
 
 
 
 
 
3
4
5
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL>