A PL/SQL block can contain a sub-block which can be placed in any section. The following describes the architecture of a PL/SQL block:
This part is optional if no variable needs to be declared.
You are not allowed to use consecutive tabs in the PL/SQL block, because they may result in an exception when the parameter -r is executed using the gsql tool.
PL/SQL blocks are classified into the following types: