Explain block structure of PL/SQL.
DECLARE
--------declarations
BEGIN
--------statements
EXCEPTIONS
--------handlers
END;
The order of the parts is quite logical:
- First comes the declarative part, in which items can be declared.
- Items can be manipulated in the executable part.
- Exceptions raised during can be handled in the exception-handling part
