WHILE Loop in Oracle PLSQL

A WHILE Loop in Oracle PLSQL is used when we are not sure as to how many times the loop’s body should be executed.

Unlike LOOP statement, a WHILE LOOP may not get executed even once as the condition to execute a WHILE LOOP is evaluated before execution of the loop.

A WHILE LOOP gets terminated whenever the condition to execute the loop evaluates to false.

The Syntax for the WHILE LOOP in Oracle PLSQL is:
WHILE condition
LOOP
{
Statements to be executed;
}
END LOOP;

Example of a WHILE LOOP in Oracle PLSQL is:

WHILE sum <= 35
LOOP
{
  sum := sum + 1;
}
END LOOP;

The above loop will execute the “sum := sum+1” statement and as soon as the value of the “sum” variable crosses 35 the loop will terminate.
It may happen that the variable “sum” is already assigned a value higher than 35, in this case the WHILE LOOP will not get executed even once.


Tagged , , , , , , , , , , , . Bookmark the permalink.
  • Hola! I’ve been following your web site for a while now and finally got the courage to go ahead and give you a shout out from New Caney Texas! Just wanted to tell you keep up the good work!