Oracle System Function - Oracle/PLSQL EMPTY_CLOB Function






This Oracle tutorial explains how to use the Oracle/PLSQL EMPTY_CLOB function.

The Oracle/PLSQL EMPTY_CLOB function is used to initialize a LOB column to EMPTY in an INSERT statement or UPDATE statement.

We can also use it to initalize a LOB variable.

Syntax

The syntax for the Oracle/PLSQL EMPTY_CLOB function is:

EMPTY_CLOB ()

There are no parameters for the EMPTY_CLOB function.

Example

UPDATE emp
 SET emp_photo = EMPTY_CLOB();