A PL/SQL code block can consist of several section types and can contain nested code blocks. This section will discuss the various code block sections, nested code blocks, and the GOTO keyword.
There are four types of code block sections:
|•Header||This is the optional first section of the code block. It is used to identify the type of code block and its name. The code block types are anonymous procedure, named procedure, and function. A header is used for only the latter two types.|
|•Declaration||This is an optional section of the code block. It contains the name of the local objects that will be used in the code block. These include variables, cursor definitions, and exceptions. This ...|