CodesJava

Easy learning with example program codes

Oracle pl sql continue statement tutorial


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

 



Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki