SQL>
SQL>
SQL> --EXIT WHEN statement
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 myValue INTEGER := 5;
3 BEGIN
4 FOR i IN 1..12 LOOP
5
6 myValue := myValue +5;
7 DBMS_OUTPUT.PUT_LINE(myValue);
8 EXIT WHEN myValue > 100;
9 END LOOP;
10 END;
11
12
13 /
10
15
20
25
30
35
40
45
50
55
60
65
PL/SQL procedure successfully completed.
SQL>