CodesJava

Easy learning with example program codes

Oracle pl sql while loop tutorial


PL SQL WHILE LOOP:

The pl sql while loop repeatedly executes a block of statements until a particular condition is true. It first check the condition and executes a block of statements if condition is true.

PL SQL WHILE LOOP syntax:

WHILE condition
 LOOP
   //block of statements;
 END LOOP;

PL SQL WHILE LOOP example:

DECLARE  
  num NUMBER := 1;  
BEGIN  
  WHILE num <= 10
  LOOP    
    DBMS_OUTPUT.PUT_LINE(num);   
    num := num+1;
  END LOOP;  
END;

Output:

1
2
3
4
5
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