SQL> BEGIN
  2    dbms_output.put_line('Before the loop');
  3    FOR cur_r IN (SELECT deptno, dname FROM DEPT
  4                  ORDER BY deptno
  5                 )
  6    LOOP
  7      IF cur_r.deptno <> 30 THEN
  8         dbms_output.put_line(cur_r.dname);
  9      ELSE
 10         dbms_output.put_line('Deptno 30 reached - exiting the loop');
 11         EXIT;
 12      END IF;
 13    END LOOP;
 14    dbms_output.put_line('The end');
 15  END;
 16     /
Before the loop
ACCOUNTING
RESEARCH
Deptno 30 reached - exiting the loop
The end

PL/SQL procedure successfully completed.

SQL>