Creating Tables Containing CLOB Objects : CLOB « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. CLOB

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>