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
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
✈️ When Flights Stop — and So Does Data: What Alaska Air’s IT Outage Reveals About Operational Resilience
- 29 October 2025
- Software Engineering
When Alaska Air grounded flights after a failure in its primary data center, it looked like a classic IT outage.But behind the headlines was a more modern truth:operations now depend on data performance as much as on hardware reliability. In aviation, a single database delay can cascade through thousands of dependencies — from ticketing to … Continue reading “✈️ When Flights Stop — and So Does Data: What Alaska Air’s IT Outage Reveals About Operational Resilience”
Boosting eCommerce Growth with Enteros: AI SQL, RevOps Efficiency, and Performance Optimization for the Digital Marketplace
- 28 October 2025
- Database Performance Management
Introduction The eCommerce landscape is evolving at an unprecedented pace. With billions of daily transactions, global supply chain integrations, and an ever-expanding digital customer base, eCommerce enterprises are under increasing pressure to maintain lightning-fast performance, accurate analytics, and cost-efficient operations.In this hyper-competitive environment, Enteros emerges as a transformative solution — combining AI SQL intelligence, RevOps … Continue reading “Boosting eCommerce Growth with Enteros: AI SQL, RevOps Efficiency, and Performance Optimization for the Digital Marketplace”
From Risk to Resilience: How Enteros Generative AI and Cloud FinOps Are Redefining Database Optimization in Insurance
Introduction The insurance industry has always been rooted in data — assessing risk, predicting trends, and ensuring long-term financial stability. Yet, in today’s digital-first ecosystem, the amount and complexity of insurance data have skyrocketed. From real-time underwriting models to automated claims processing and customer personalization, insurers depend heavily on vast, dynamic, and distributed databases. Managing … Continue reading “From Risk to Resilience: How Enteros Generative AI and Cloud FinOps Are Redefining Database Optimization in Insurance”
Driving Financial RevOps Efficiency with Enteros: AIOps-Powered Database Performance for Smarter Decision-Making
- 27 October 2025
- Database Performance Management
Introduction In today’s competitive financial ecosystem, where every second and every data point matters, achieving operational agility and revenue precision has become a top priority. Financial institutions — from banks and insurance companies to fintech innovators — are seeking more intelligent ways to manage their data-driven operations. The convergence of Revenue Operations (RevOps), database performance … Continue reading “Driving Financial RevOps Efficiency with Enteros: AIOps-Powered Database Performance for Smarter Decision-Making”