Explain the GOTO and CONTINUE statements in PL/SQL loops

How it works

CONTINUE [WHEN condition] skips the rest of the current loop iteration and moves straight to the next one. GOTO <<label>> transfers control unconditionally to a labeled statement within the same block's flow — it can't jump into a loop, IF, or sub-block from outside it, or out of a subprogram, and is generally discouraged in favor of structured control (IF/loops/EXIT) except for a few specific idioms.

BEGIN
  FOR v_i IN 1..5 LOOP
    CONTINUE WHEN MOD(v_i, 2) = 0;
    DBMS_OUTPUT.PUT_LINE('Odd: ' || v_i);
  END LOOP;

  FOR v_i IN 1..5 LOOP
    IF v_i = 3 THEN
      GOTO skip_print;
    END IF;
    DBMS_OUTPUT.PUT_LINE('Value: ' || v_i);
    <<skip_print>>
    NULL;
  END LOOP;
END;
/

Related Questions