Oracle/PL/SQL

PL/SQL Block Structure

Figo Kim 2006. 12. 31. 05:06

DECLARE (Optional)

    Variables, cursors, user-defined exceptions

BEGIN (Mandatory)

- SQL Statements

- PL/SQL statements

EXCEPTION

    Actions to perform when errors occur

END; (Mandatory)

** The END block is terminated with a semicolon.