CLOB

A CLOB (Character Large Object) is an Oracle data type that can hold up to 4 GB of data. CLOBs are handy for storing text.
In 12c, the storage limit is extended to (4*1024*1024*1024-1) * CHUNK size given in the LOB STORAGE clause defining the LOB (database block size by default).

Examples

CREATE TABLE t1(id NUMBER, doc CLOB);
INSERT INTO t1 VALUES (1, 'some CLOB data');

Also see

• NCLOB - similar to CLOB, but characters are from the database national character set
• BLOB - Binary large Object

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#