PL/SQL Continue Statement

PL/SQL Continue Statement:

The PL/SQL continue statement is a control statement that is used to skip the following statement in the body of the loop and continue with the next iteration of the lPL/SQL continue syntax:

continue; 

PL/SQL Continue Statement Example:

DECLARE  
  num NUMBER := 0;  
BEGIN  
  WHILE num < 10
  LOOP 
    num := num +1;
    IF num = 5 THEN
      CONTINUE;
    END IF;
    DBMS_OUTPUT.PUT_LINE(num); 
  END LOOP;  
END;

Output:

1
2
3
4
6
7
8
9
10

Alex Martin