CLOB
CLOB, character LOB type, is used to store character data.
Creating Tables Containing Large Objects
CREATE TABLE my_clob(
id INTEGER PRIMARY KEY,
clob_column CLOB NOT NULL
);
INSERT INTO my_clob (id, clob_column) VALUES (1, TO_CLOB('a string'));
INSERT INTO my_clob (id, clob_column) VALUES (2, TO_CLOB('asdf'););
SELECT * FROM my_clob;
UPDATE my_clob
SET clob_column = TO_CLOB('aaa')
WHERE id = 1;