The power of PL/SQL is that it allows the developer to read data into the code block and to manipulate it. In order to bring the attributes into the program, you must have variables that will hold the values. Oracle cannot use the values until they are placed into memory, which happens when they are assigned to a variable. Variables are defined in the declaration section of the code block and will be discussed in this section.
Variables are defined in the declaration section of the program. The syntax is as follows:
Oracle treats a variable definition similarly to other statements. The definition must end with a semicolon. The definition statement ...