When a large amount of alphanumeric data needs to be stored in one record, the CLOB data type should be used.
CLOB stands for “Character Large Object.” The CLOB data type allows for the storage of up to 4GB of data. It’s basically the same as the VARCHAR2 data type, with the exception that it allows for the storage of much longer strings of data.
Note that the CLOB data type stores only alphanumeric data. If it is necessary to store other types of data, such as sound or video, the BLOB data type should be used.
Filed under: Oracle, Programming, Software, pl/sql | Tagged: clob, data types
Thank you for this plain explanation. I’ve been looking for a simple answer and yours is exactly what I needed to understand the different data types of BLOB and CLOB.