Wednesday, October 5, 2011

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;
Post a Comment