SQL> SQL> CREATE TABLE MyTable ( 2 id INTEGER PRIMARY KEY, 3 clob_column CLOB NOT NULL 4 ); Table created. SQL> SQL> desc myTable; Name Null? Type --------------- ID NOT NULL NUMBER(38) CLOB_COLUMN NOT NULL CLOB SQL> SQL> drop table myTable; Table dropped. SQL>