PL/SQL

if .. then

...

elsif .. then

...

elsif .. then

...

else

...

end if;

exit[ <label>][ when ..];

[FOR counter IN [REVERSE] lower_bound..higher_bound|while ... ]LOOP

   ...

END LOOP;

<<main>>

DECLARE

   ctr  INTEGER;

   ...

BEGIN

   ...

   FOR ctr IN 1..25 LOOP

      ...

      IF main.ctr > 10 THEN  -- refers to global variable

         ...

      END IF;

   END LOOP;

END main;

<<outer>>

FOR step IN 1..25 LOOP

   FOR step IN 1..10 LOOP

      ...

      IF outer.step > 15 THEN ...

   END LOOP;

END LOOP[ outer];

<<FIRST_LOOP>>

loop

...

<<SECOND_LOOP>>

loop

...

exit SECOND_LOOP WHEN ...;

exit FIRST_LOOP WHEN ...;

...

end loop[ SECOND_LOOP];

end loop[ FIRST_LOOP];

참조 사이트:

http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm