Oracle EMPTY_CLOB Function


/ Published in: SQL
Save to your folder(s)

A few examples of the EMPTY_CLOB function.


Copy this code and paste it in your HTML
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.