title: What is the best way to search the Long datatype within an Oracle database?
body: <p>I am working with an Oracle database that stores HTML as a Long datatype.  I would like to query the database to search for a specific string within the HTML data stored in the Long.  </p>
  
  <p>I tried, "select * from TABLE where COLUMN like '%form%'".  This causes the following Oracle error because "like" is not supported for Long datatypes.</p>
  
  <p>ORA-00932: inconsistent datatypes: expected NUMBER got LONG</p>