While Loop PL/SQL

by

The PL/SQL while loop repeatedly executes a block of statements until a particular condition is true. It first checks the condition and executes a block of statements if the 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