CLOB stands for Character Large Object. This topic describes how to use the CLOB data type and provides examples.
Considerations
The CLOB data type is used to store single-byte and multibyte character data. CLOB supports both fixed-width and variable-width character sets, and both use the database character set. The maximum length of a CLOB in bytes is 536,870,910 bytes, and the character set is the same as the tenant's character set.
The maximum length of a VARCHAR2 field is 32,767 bytes. If the length of the field you want to store exceeds 32,767 bytes, use the CLOB data type. You can also use the CLOB data type to store CHAR data, such as XML documents.
CLOB objects support complete transaction support. Changes made through SQL or the DBMS_LOB system package are part of the transaction, meaning that CLOB value operations can be committed or rolled back. However, you cannot save a CLOB locator in a PL/SQL variable in one transaction and then use it in another transaction or session.
Examples
Create a table named clob_tbl and set the clob_col column to the CLOB data type.
obclient> CREATE TABLE clob_tbl (clob_col CLOB);
Query OK, 0 rows affected