December 2002
Intermediate to advanced
928 pages
85h 29m
English
Whenever you declare a variable, it is assigned a default value of NULL. Initializing all variables is distinctive to PL/SQL; in this way, PL/SQL differs from languages such as C and Ada. If you want to initialize a variable to a value other than NULL, you do so in the declaration with either the assignment operator (:=) or the DEFAULT keyword:
counter BINARY_INTEGER := 0; priority VARCHAR2(8) DEFAULT 'LOW';