Variable PL / SQL Data Types
PL/SQL datatypes
The correct values and their datatypes are:
- TRUE : SCALAR datatype
- RECORD : COMPOSITE datatype
- %ROWTYPE : REFERENCE datatype
- BLOB : LOB datatype
Every constant, variable, and parameter has a datatype (or type), which specifies a storage format, constraints, and valid range of values.
PL/SQL provides many predefined datatypes. For instance, you can choose from
PL/SQL provides many predefined datatypes. For instance, you can choose from
- integer,
- floating point,
- character,
- BOOLEAN,
- date,
- collection,
- reference, and
- large object (LOB) types.