Advanced Search

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