PL/SQL: Control Structures

Shafeen

Control Structures

• Conditions checking

IF THEN
[ELSIF THEN]
[ELSE THEN]
END IF;

• Basic loops.

LOOP
...
EXIT WHEN
END LOOP;

• FOR loop.

FOR counter IN lower_bound .. upper_bound
...
END LOOP;

• WHILE loop.

WHILE LOOP
...
END LOOP;