while loop plsql

by

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