Initialize CLOB column : CLOB « Large Objects « Oracle PL/SQL Tutorial

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

SQL> CREATE TABLE MyTable (
  2    id          INTEGER PRIMARY KEY,
  3    clob_column CLOB NOT NULL
  4  );

Table created.

SQL>
SQL>
SQL> INSERT INTO myTable(id, clob_column) VALUES (1, EMPTY_CLOB());

1 row created.

SQL>
SQL> select * from mytable;

        ID CLOB_COLUMN
---------- -----------
         1

SQL>
SQL> drop table myTable;

Table dropped.

SQL>