SQL>
SQL> -- Using EXIT with a WHILE loop.
SQL> DECLARE
2 r NUMBER := 2;
3 BEGIN
4 WHILE TRUE LOOP
5 DBMS_OUTPUT.PUT_LINE('The Area is ' || mypi * r * r);
6 IF r = 10 THEN
7 EXIT;
8 END IF;
9 r := r + 2 ;
10 END LOOP;
11 END;
12 /
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>
|