CLOB

From Oracle FAQ
Jump to: navigation, search

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.

[edit] Examples

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

[edit] Also see

  • NCLOB - similar to CLOB, but characters are stored in a multibyte 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 #