What are the different datatypes that can be defined in a PL/SQL block?

The following categories of datatypes are supported by PL/SQL:
1. Scalar —Holds a single value and does not contain any internal component.
Some of its datatypes are given as follows:
CHAR
VARCHAR2
NUMBER
LONG
INT
INTEGER
BINARYINTEGER
DATE
BOOLEAN
SMALLINT
POSITIVE
POSITIVEN
2. Composite —Contains an internal component, which can be manipulated individually.
It is also known as collections and includes the following datatypes:
TABLE
RECORD
NESTED TABLE
VARRAY
3. Reference —Holds values called pointers, which designate to other objects.
It includes the following datatypes:
REF CURSOR
REF object_type
4. LOB —Holds values, which specify the location of large objects, such as images and video clips. It can store up to 4GB of unstructured data.
It includes the following datatypes:
BFILE
BLOB
CLOB
NCLOB

Posted in: PL SQL Interview Questions And Answers