Posted By

bbrumm on 03/13/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/13/17 05:13am

Statistics

Viewed 986 times

Favorited by 0 user(s)

Related snippets

Oracle EMPTY_BLOB Function

/ Published in: SQL

A few examples of the EMPTY_BLOB function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;