CLOB
From Oracle FAQ
(Redirected from Clob)
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
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 | # |
