Posted By

bbrumm on 03/14/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/14/17 03:48pm

Statistics

Viewed 883 times

Favorited by 0 user(s)

Related snippets

Oracle EMPTY_CLOB Function

/ Published in: SQL

A few examples of the EMPTY_CLOB function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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;