title: How to include the column USER_VIEWS.TEXT in a where clause
body: <p>This seems like it should have been an easy thing to figure out but I am struggling to find any answers.</p>
  
  <p>I want to be able to query against the USER_VIEWS table in Oracle to find other views that are using a particular table.</p>
  
  <p>Something like:</p>
  
  <blockquote>
    <p>SELECT view_name, text FROM user_views
    WHERE text LIKE'%MY_TABLE%'</p>
  </blockquote>
  
  <p>I get the error:
  ORA-00932: inconsistent datatypes: expected NUMBER got LONG</p>
  
  <p>The datatype for TEXT is LONG and in TOAD it shows WIDEMEMO.</p>
  
  <p>I have tried casting it, to_char and concatenating.  I tried creating another table with just the TEXT data and I get ORA-00997: illegal use of LONG datatype.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks!</p>