|Oracle® Database PL/SQL Language Reference
11g Release 2 (11.2)
Part Number E17126-03
A scalar variable stores a value with no internal components. The value can change.
A scalar variable declaration specifies the name and data type of the variable and allocates storage for it. The declaration can also assign an initial value and impose the
You reference a scalar variable by its name.
See "expression ::=".
The name of the variable that you are declaring.
The name of a scalar data type, including any qualifiers for size, precision, and character or byte semantics. For information about scalar data types, see Chapter 3, "PL/SQL Data Types".
NULL constraint on the variable. For information about this constraint, see "NOT NULL Constraint".
The value to be assigned to the variable when the declaration is elaborated. The value of
expression must be of a data type that is compatible with the data type of the variable.
In this chapter:
In other chapters: