Oracle EMPTY_BLOB function

Preamble

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

EMPTY_BLOB ()

Parameters or arguments

There are no parameters or arguments for the EMPTY_BLOB function.

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

Consider an example of the Oracle EMPTY_BLOB function and learn how to use the EMPTY_BLOB function in Oracle PLSQL.

UPDATE prods
SET prod_photo = EMPTY_BLOB();

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

The Oracle EMPTY_BLOB function is used to initialise a LOB column

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.​