PL/SQL Looping

LOOPING STRUCTURE

Looping Statements

==================

Simple Loop

=========

                loop

                                stmts;

                                increment/decrement;

                                exit when condition

                end loop;

while loop

========

                while (condition)

                loop

                                stmts;

                                increment/decrement;

                end loop;

for loop

======

                for i in starting_value..ending_value

                loop

                                stmts;

                end loop;