Notice: Constant WP_MEMORY_LIMIT already defined in /home/javawith/public_html/codesjava.com/wp-config.php on line 107

Notice: Constant WP_MAX_MEMORY_LIMIT already defined in /home/javawith/public_html/codesjava.com/wp-config.php on line 108
Continue in pl sql oracle - CodesJava

CodesJava

Easy learning with example program codes

continue in pl sql oracle


Notice: Undefined variable: footnotelist in /home/javawith/public_html/codesjava.com/wp-content/plugins/latex2html/inc/core.php on line 475

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:
error








Copyright © 2019 CodesJava DMCA.com Protection Status