How to extract data from LONG datatype field using only SQL (without using PL/SQL block)?
<p>How to extract data from <code>LONG</code> datatype field using only SQL (without using PL/SQL)?
Getting error while concatenating with other columns- </p>

<blockquote>
  <p>ORA00932: inconsistent datatypes</p>
</blockquote>

<p>DB: Oracle 8i enterprise edition</p>