Posted By

bbrumm on 03/14/17


Tagged

sql Oracle


Versions (?)

Oracle EMPTY_CLOB Function


 / Published in: SQL
 

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

A few examples of the EMPTY_CLOB function.

  1. CREATE TABLE clobtest (
  2. clobval CLOB
  3. );
  4.  
  5. INSERT INTO clobtest (clobval) VALUES ('qwerty');
  6.  
  7. SELECT clobval
  8. FROM clobtest;
  9.  
  10. UPDATE clobtest
  11. SET clobval = EMPTY_CLOB();
  12.  
  13. SELECT clobval
  14. FROM clobtest;
  15.  
  16. UPDATE clobtest
  17. SET clobval = NULL;
  18.  
  19. SELECT clobval
  20. FROM clobtest;

Report this snippet  

You need to login to post a comment.