A Comparison of PL/SQL Block Syntax
ANONYMOUS

[DECLARE
CREATE
FUNCTION
CREATE
PROCEDURE
CREATE
PACKAGE
CREATE
PACKAGE BODY
[parameters] [parameters]
RETURN
declaration
section]
declaration
section
declaration
section
declaration
section
declaration
section
BEGIN BEGIN BEGIN [BEGIN
executable
section
executable
section
executable
section
executable
section]
[EXCEPTION [EXCEPTION [EXCEPTION [EXCEPTION
exception-
handling
section]
exception-
handling
section]
exception-
handling
section]
exception-
handling section]
END; END; END; END; END;
// ///