Large Volume of Character Data Type In Oracle

Oracle support large volume of character data in below listed data types.

LONG data type

The LONG data type has character data of variable length.
The LONG have Maximum length up to 2 gigabytes.

CLOB data type

The CLOB data type is character large object containing single-byte or multibyte characters.
The CLOB have Both fixed-width and variable-width character sets are supported, both using the database character set.
The CLOB have Maximum size is (4 gigabytes – 1) * (database block size) up to 128 terabytes depending on block size

NCLOB data type

The NCLOB data type is character large object containing Unicode characters.
The NCLOB have Both fixed-width and variable-width character sets are supported, both using the database national character set.
The NCLOB have Up to 128 terabytes depending on block size , same as CLOB.