Using EXIT with a WHILE loop

 

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>

Related examples in the same category

1.	Impact of EXIT in a function
2.	Using EXIT with a simple LOOP
3.	Using EXIT with a FOR loop
4.	Unconstrained loop: exit
5.	Exit outer loop with 'EXIT LabelName When' statement
6.	EXIT WHEN clause.
7.	Exit to a label
8.	Exit loop since last index value is read.

Using EXIT with a WHILE loop : EXIT « PL SQL « Oracle PL / SQL

Related examples in the same category