SQL : Type of Variable in Oracle

There are 3 basic category of variables in Oracle

1 Scaler

2. Composite

3 Reference.

WHAT IS A VARIABLE IN ORACLE?

In Oracle/PLSQL, a variable allows a programmer to store data temporarily during the execution of code.

SYNTAX

The syntax for declaring variables in Oracle is:

variable_name [CONSTANT] datatype [NOT NULL] [:= | DEFAULT initial_value]

variable_name: The name to assign to the variable.
CONSTANT: Optional. If specified, the variable's value is constant and can not be changed.
datatype: The datatype to assign to the variable

--------------------------------------