Google News
logo
PL/SQL - Interview Questions
What are the data types present in PL/SQL?
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.
Advertisement