There are various kinds of data types are available in PL/SQL which are :
Scalar data types : A scalar data type is a one-dimensional data type with no internal components. CHAR, DATE, LONG, VARCHAR2, NUMBER, BOOLEAN
are some examples of scalar data types.
Composite data types : A composite data type is made up of different data types that are easy to update and have internal components that can be utilized and modified together. For instance, RECORD, TABLE, VARRAY
, and so on.
Reference data types : A reference data type stores pointers, which are values that relate to other programs or data elements. REF, CURSOR
is an example of a reference data type.
Large object data type : A large object data type stores locators, which define the location of large items stored out of line (such as video clips, graphic images, and so on). BLOB, BFILE, CLOB, NCLOB
, and others are examples of large object data types.