title: How to get XML from a BLOB field in Oracle Database 11g?
body: <p>This is the scenario, in a Oracle Database 11g, theres a BLOB field which has XML data which I need to query. I don't know how the XML was inserted into the blob field, but this is what I'm getting with a query using the DBMS_LOB.substr() function:</p>
  
  <p><a href="https://i.stack.imgur.com/cKCZD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cKCZD.png" alt="enter image description here"></a></p>