Oracle System Function - Oracle/PLSQL EMPTY_BLOB Function






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

The Oracle/PLSQL EMPTY_BLOB 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_BLOB function is:

EMPTY_BLOB ()

There are no parameters for the EMPTY_BLOB function.

Example

UPDATE emp
 SET emp_photo = EMPTY_BLOB();