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:
Example of PL/SQL While Loop
Let's see a simple example of PL/SQL WHILE loop.
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.
PL/SQL WHILE Loop Example 2
200 400 600 800 1000 1200 1400 1600 1800 2000