sql: PL/SQL proc

A PL/SQL block has the following structure:

[DECLARE
declaration_statements
]
BEGIN
executable_statements
[EXCEPTION
exception_handling_statements
]
END;
/

　　[]中是可选的.