CONTINUE inside a PL/SQL loop
Today lets see how to use CONTINUE inside a PL/SQL loop. The CONTINUE statement skips the rest of the current iteration and moves to the next one.
SQL> DECLARE
2 v_counter NUMBER := 0;
3 BEGIN
4 FOR i IN 1..10 LOOP
5 -- Skip even numbers
6 IF MOD(i, 2) = 0 THEN
7 CONTINUE;
8 END IF;
9
10 v_counter := v_counter + 1;
11 DBMS_OUTPUT.PUT_LINE('Processing odd number: ' || i);
12 END LOOP;
13
14 DBMS_OUTPUT.PUT_LINE('Total odd numbers processed: ' || v_counter);
15 END;
16* /
PL/SQL procedure successfully completed.Explanation: The loop runs from 1 to 10. When the number is even (MOD(i, 2) = 0), CONTINUE skips to the next iteration. Only odd numbers are processed and counted.
