December 2002
Intermediate to advanced
928 pages
85h 29m
English
Before you can use a variable, you must first declare it in the declaration section of your PL/SQL block or in a package as a global. When you declare a variable, PL/SQL allocates memory for the variable’s value and names the storage location so that the value can be retrieved and changed. The syntax for a variable declaration is:
variable_namedatatype[CONSTANT] [NOT NULL] [:= | DEFAULTinitial_value]