Oracle provides four data types dedicated for declaring large objects, namely: BLOB
, CLOB
, NCLOB
, and BFILE
.
There are three types of internal LOB
data types, namely:
BLOB
: The Binary Large Object data type is used to store large binary files that cannot be logically broken down to data bits such as PDFs, images, audios or videos, and so on.CLOB
: The Character Large Object data type stores the single-byte character data in the database character set format. It supports fixed-width character formats.NCLOB
: TheCLOB
data type that can store national character set data and support varying width format character sets.