PL/SQL Data Types - Oracle

As you know about the variables and constants stores value in specific storage format. There are six built-in PL/SQL Data types

1. Scalar data types - Scalar data types haven't internal components.
2. Composite data types - Composite data types have internal components to manipulate data easily.
3. Reference data types - This data types works like a pointer to hold some value.
4. LOB data types - Stores large objects such as images, graphics, video.
5. Unknown Column types - Identify columns when not know type of column.
6. User Define data types - Define your own data type that are inherit from predefined base data type.

Scalar types

Scalar data type haven't internal components. It is like a linear data type. Scales data type divides into four different types character, numeric, boolean or date/time type.

Numeric Data types

Following are numeric data types in PL/SQL: