Oracle EMPTY_BLOB Function


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

A few examples of the EMPTY_BLOB function.


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

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.