Tip: How to convert Oracle BLOB to VARCHAR for temporary viewing - SQL

 

   1: SELECT

   2: utl_raw.cast_to_varchar2

   3: (

   4:     dbms_lob.substr

   5:     (

   6:         BLOB_COLUMN, dbms_lob.getLength(BLOB_COLUMN), 1

   7:     )

   8: ) BLOB_AS_VARCHAR

   9: FROM THE_TABE 

Interesting huh?...