title: Convert LONG into VARCHAR2 or some text datatype
body: <p>As we all know LONG is deprecated in Oracle a long back but Oracle itself is still using this datatype in their views.</p>
  
  <p>So if I have to change LONG into some kind of text datatype how can I achieve that. </p>
  
  <p>I am trying to query this and getting error.</p>
  
  <pre><code>ORA-00932: inconsistent datatypes: expected - got LONG
  </code></pre>
  
  <p>Query -</p>
  
  <pre><code>SELECT NVL(ie.column_expression, ic.column_name)
  from user_ind_columns ic left join user_ind_expressions ie  on ic.index_name = ie.index_name and ic.table_name = ie.table_name 
  where ic.table_name = 'Some Table'
  </code></pre>