Return to Snippet

Revision: 71806
at March 14, 2017 15:48 by bbrumm


Initial Code
CREATE TABLE clobtest (
clobval CLOB
);

INSERT INTO clobtest (clobval) VALUES ('qwerty');

SELECT clobval
FROM clobtest;

UPDATE clobtest
SET clobval = EMPTY_CLOB();

SELECT clobval
FROM clobtest;

UPDATE clobtest
SET clobval = NULL;

SELECT clobval
FROM clobtest;

Initial URL
http://www.databasestar.com/oracle-empty_clob

Initial Description
A few examples of the EMPTY_CLOB function.

Initial Title
Oracle EMPTY_CLOB Function

Initial Tags
sql, Oracle

Initial Language
SQL