Oracle EMPTY_BLOB Function - SQL Snipplr Social Repository

Revision: 71801

at March 13, 2017 05:13 by bbrumm

Initial Code

CREATE TABLE blobtest (
blobval BLOB
);

INSERT INTO blobtest (blobval) VALUES ('abcde');

SELECT blobval
FROM blobtest;

SELECT DBMS_LOB.SUBSTR(blobval)
FROM blobtest;

UPDATE blobtest
SET blobval = EMPTY_BLOB();

SELECT DBMS_LOB.SUBSTR(blobval)
FROM blobtest;

UPDATE blobtest
SET blobval = NULL;

SELECT DBMS_LOB.SUBSTR(blobval)
FROM blobtest;

Initial URL

http://www.databasestar.com/oracle-empty_blob

Initial Description

A few examples of the EMPTY_BLOB function.

Initial Title

Oracle EMPTY_BLOB Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: