Writing Control Structures

 Writing Control Structures:

• PL/SQL can also process data using flow of control statements.
• PL/SQL helps us manipulates and process oracle data using control statements.
• The flow of control statements can be classified under the following categories:

                             i). Conditional control.
                            ii). Iterative control.
                           iii). Sequential  control.

The statement structures provided by PL/SQL for this purpose are.

• IF-THEN-ELSE
• END IF
• ELSIF
• CASE
• END CASE
• LOOP
• FOR-LOOP
• WHILE-LOOP
• END LOOP
• EXIT-WHEN and
• GOTO

By integration all the above statements in a proper way a PL/SQL programmer can handle any real time situation.