continue plsql

Pl sql continue statement:

The pl sql continue statement is a control statement which is used to skip the following statement in the body of the loop and continue with the next iteration of the loop.

Pl 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

Please follow and like us: