PL/SQL blocks and variables

PL/SQL blocks are groups of one or more SQL or PL/SQL statements that are enclosed within a BEGIN and END block. PL/SQL variables are used to store values that can be referenced and manipulated within a PL/SQL block. Here is an example of a simple PL...