PL/SQL While Loop
PL/SQL 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
LOOP statements;
END LOOP;
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
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.
