Explain block structure of PL/SQL.
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