«
»

The Oracle CLOB data type

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.

Possibly related posts: (automatically generated)

This entry was posted on July 23, 2008 at 7:10 am and is filed under Oracle, Software, pl/sql, programming with tags , . 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.

2 Responses to “The Oracle CLOB data type”

  1. Shanan Worley Says:
    September 27, 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.

    Reply
  2. Sebrina Willms Says:
    January 8, 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

    Reply

Leave a Reply