A PL/SQL block contains one or more PL/SQL statements. Such a block must at least have the two keywords begin and end:
However, such a block cannot declare any (local) variables. In order to have local variables, the begin...end block must be preceeded with a declare followed by the variable declarations:
Additinonally, it is possible to have a exception handler as part of the block. The exception keyword is required for this:
A block can be named. Such a label can then be the target of a goto and exit statement.
A block can be (recursively) nested, that is, a block can contain other blocks, which in turn can again contain other blocks asf.
Building PL/SQL Blocks, PL-SQL, pl-sql, PL-SQL Tutorial, PL-SQL tutorial pdf, history of PL-SQL, PL-SQL Administration, learn PL-SQL