SQL data types for Oracle/PLSQL
PLSQL datatypes
In this article, we will understand briefly PLSQL datatypes. Each value in PL/SQL such as constant, variable, or parameter has a data type that defines their storage and calculation behavior. PL/SQL has basically two types of data types e.g scalar and composite.
Types of sql data types
Scalar data types
In scalar data type are those data type that stores a single value. Scalar data type has further four data subtypes
- Number
- Boolean
- Character
- Datetime
Composite data types
Whereas composite data type stores multiple values. There are two data sub types of composite data types are available.
- Record
- Collection
In this article, we will be discussing only scalar data type
Oracle number data type
The numeric data … Continue Reading