Enlist the data types that can be used in PL/SQL?

Each constant, value and parameter has a data type that tells us the type of data used and their associated operations in the program. The following are four data types available in PL/SQL:

1. Scalar data type-these are single-valued data types with no internal components. They are further classified into four categories-
2. CHAR– these data types hold the fixed-length character strings. Its value ranges from 1 to 32,767 characters.
3. VARCHAR2– these data types store variable-length character strings ranging from 1 to 32,767 characters.
4. BOOLEAN– it is a data type with two values, true or false, intended to represent the truth values of logic and Boolean algebra.
5. DATE– it is a data type for storing date and time information.
6. LONG– it is an Oracle data type for storing character data of variable length.

1. Composite data type- it is a combination of other data types and internal components that can be easily altered and manipulated. These include record, table and array.
2. Reference data type- it is a data type that holds pointers to other data items. Ref Cursor is an example.
3. Large object data type- These data types hold locators that defines the location of large objects stored out of the line. These are stored separately from other data items.