|
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>
|