Oracle SQL: the Essential Reference

EMPTY_CLOB

EMPTY_CLOB( )

Returns an empty CLOB locator, which can be used to initialize a CLOB column.

Example

SQL> CREATE TABLE x(c clob);

Table created.

SQL> INSERT INTO x (c) VALUES (EMPTY_CLOB(  ));

1 row created.

Unlike other functions, EMPTY_CLOB must be followed with parentheses even though no parameters are passed.