While Loop

PL/SQL while loop is used when a set of statements has to be executed as long as a condition is true, the While loop is used. The condition is decided at the beginning of each iteration and continues until the condition becomes false.

Syntax of while loop:

WHILE <condition>   

 LOOP statements;   

END LOOP; 

Example of PL/SQL While Loop

Let’s see a simple example of PL/SQL WHILE loop.

DECLARE  

i INTEGER := 1;  

BEGIN  

WHILE i <= 10 LOOP  

DBMS_OUTPUT.PUT_LINE(i);  

i := i+1;  

END LOOP;  

END;  

After the execution of the above code, you will get the following result:

1
2
3
4
5
6
7
8
9
10

Note: You must follow these steps while using PL/SQL WHILE Loop.

• Initialize a variable before the loop body.
• Increment the variable in the loop.
• You can use EXIT WHEN statements and EXIT statements in While loop but it is not done often.

PL/SQL WHILE Loop Example 2

DECLARE   

VAR1 NUMBER;  

VAR2 NUMBER;  

BEGIN   

VAR1:=200;  

VAR2:=1;  

WHILE (VAR2<=10)  

LOOP  

DBMS_OUTPUT.PUT_LINE (VAR1*VAR2);  

VAR2:=VAR2+1;  

END LOOP;  

END;

Output:

200
400
600
800
1000
1200
1400
1600
1800
2000