« List All Stored Procedures in MySQL
Oracle Tablespaces »

The Oracle CLOB data type

If this post helps you, click an ad

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.

Tags: ,

This entry was posted on Wednesday, July 23rd, 2008 at 7:10 am and is filed under Oracle, Software, pl/sql, programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “The Oracle CLOB data type”

  1. Shanan Worley Says:
    September 27th, 2008 at 5:22 am

    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.

  2. tarandeep Says:
    December 13th, 2008 at 11:44 am

    is there a possibility that newline and space charecters are not stored while saving text data in CLOB.

    We’re facing an issue, where in xml data has some preformatted test sections in CDATA section, which when stored and later retrieved from clob column, preformatting goes away

    regards,
    taran

  3. Sebrina Willms Says:
    January 8th, 2010 at 12:34 am

    ideas to share to each reader. I hope to read more from you guys and continue that good work that

Leave a Reply