FOR Loop in Oracle PLSQL

A FOR Loop in Oracle PLSQL is used to execute a portion of code i.e. the body of loop, a fixed number of times.

The Syntax for the FOR LOOP in Oracle PLSQL is:
FOR loop_counter IN [REVERSE] low_number .. high_number
LOOP
{
Statements to be executed;
}
END LOOP;

Example of a FOR Loop in Oracle PLSQL is:

FOR cnt IN 1..35
LOOP
{
  sum := sum + 1;
}
END LOOP;

The above loop will execute the “sum := sum + 1; statement 35 times. The loop will start counting from 1 and ends at 35.


Example of a FOR Loop IN REVERSE in Oracle PLSQL is:

FOR cnt IN REVERSE 1..30
LOOP
{
  sum := sum + 1;
}
END LOOP;

The above loop will execute the “sum := sum+1; statement 30 times. The loop will start counting from 30 and ends at 1 looping backwards.


Tagged , , , , , , , , , , , . Bookmark the permalink.