On 11/25/2013 06:13 PM, David Johnston wrote:
>
> A side observation: why does "DECLARE" not require a block-end keyword but
> instead "BEGIN" acts as effectively both start and end? BEGIN, IF, FOR,
> etc... all come in pairs but DECLARE does not.
>
>
A complete block is:
[ DECLARE declarations ]
BEGIN statements
[ EXCEPTIONS handlers ]
END
The declare and exceptions parts are optional, as indicated. Does that
make it clearer?
cheers
andrew