advanced code snippet search

Posted By

bbrumm on 03/13/17


Tagged

sql Oracle


Versions (?)

Oracle EMPTY_BLOB Function

 / Published in: SQL
 

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

A few examples of the EMPTY_BLOB function.

Expand | Embed | Plain Text 
  1. CREATE TABLE blobtest (
  2. blobval BLOB
  3. );
  4.  
  5. INSERT INTO blobtest (blobval) VALUES ('abcde');
  6.  
  7. SELECT blobval
  8. FROM blobtest;
  9.  
  10. SELECT DBMS_LOB.SUBSTR(blobval)
  11. FROM blobtest;
  12.  
  13. UPDATE blobtest
  14. SET blobval = EMPTY_BLOB();
  15.  
  16. SELECT DBMS_LOB.SUBSTR(blobval)
  17. FROM blobtest;
  18.  
  19. UPDATE blobtest
  20. SET blobval = NULL;
  21.  
  22. SELECT DBMS_LOB.SUBSTR(blobval)
  23. FROM blobtest;

Report this snippet  

You need to login to post a comment.