Scalar Variable Declaration

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 NOT NULL constraint.

You reference a scalar variable by its name.

LNPLS1816Topics

• Syntax

• Semantics

• Examples

• Related Topics

Syntax

LNPLS1358variable_declaration ::=

Description of the illustration variable_declaration.gif

See "expression ::=".

Semantics

LNPLS1376variable

Name of the variable that you are declaring.

LNPLS1373datatype

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".

LNPLS1817NOT NULL

Imposes the NOT NULL constraint on the variable. For information about this constraint, see "NOT NULL Constraint".

LNPLS1366expression

Value to be assigned to the variable when the declaration is elaborated. expression and variable must have compatible data types.

Examples

• Example 2-9, "Scalar Variable Declarations"

• Example 2-11, "Variable and Constant Declarations with Initial Values"

• Example 2-12, "Variable Initialized to NULL by Default"

• Example 2-13, "Variable Declaration with NOT NULL Constraint"

Related Topics

LNPLS1818In this chapter:

• "Assignment Statement"

• "Collection Variable Declaration"

• "Constant Declaration"

• "Expression"

• "Record Variable Declaration"

• "%ROWTYPE Attribute"

• "%TYPE Attribute"

LNPLS1819In other chapters:

• "Variable Declarations"

• Chapter 3, "PL/SQL Data Types"