Oracle EMPTY_CLOB function

Preamble

Oracle PLSQL EMPTY_CLOB function can be used to initialize empty LOB columns in INSERT or UPDATE operators or it can be used to initialize LOB variable.

Oracle/PLSQL syntax of EMPTY_CLOB function

EMPTY_CLOB ()

Parameters or arguments

There are no parameters or arguments for the EMPTY_CLOB function.

The EMPTY_CLOB function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the Oracle EMPTY_CLOB function and learn how to use the EMPTY_CLOB function in Oracle PLSQL.

UPDATE customs
SET custom_photo = EMPTY_CLOB();

This example EMPTY_CLOB initializes the product_photo column into an empty column. This is different from setting a LOB field to null or a LOB row with length 0.

BLOB and CLOB in Oracle Database

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​