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.