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;
Home »
Oracle »
Data types » 

CLOB:
  1. CLOB
  2. EMPTY_CLOB() stores an empty CLOB
Related: