/ 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;
URL: http://www.databasestar.com/oracle-empty_clob