title: How to read BLOB from oracle db?
body: <p>I'm trying to read BLOB data in the form of string from oracle db using sql developer.</p>
  
  <p>This is the query that I'm using :</p>
  
  <pre><code> select utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_COL,2000)) from BLOB_TABLE where BLOB_ID= 997600;
  </code></pre>
  
  <p>But the output what I get is machine readable format and not text.
  Any suggestions on how to change this query?</p>