Demonstrating a REPEAT...UNTIL loop : Repeat Until « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. 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>
           
       

Related examples in the same category