Oracle pl/sql loop structure
A loop in pl/sql is a repeating control structure that repeats a piece of code.
There are different kinds of loops:
A for loop repeats a code block a specified number of times.
The statement begins with �for�..�loop� and ends with �end loop .
for counter in [reverse] lower_bound..higher_bound loop
With lower_bound and higher_bound integer values.
Normal loop in Oracle
A normal loop starts with �loop� and ends with �end loop�.
The loop will be stopped when the EXIT statement is reached.
You can also use the RETURN statement to complete pl/sql block before its normal end is reached.
EXIT when �;
if (condition) then
EXIT outer WHEN condition;
end loop outer;
The while loop statement repeats a code block until a condition is reached.
The statement starts with �while [condition] loop� and ends with �end loop�.
while (condition) loop