title: Oracle Error: inconsistent datatypes
body: <p>I am using the following query in my ORACLE(10g) DB. </p>
  
  <p><strong>SELECT * from student_table where student_no like '%STUDENT%' 
  INTERSECT 
  SELECT * from student_table where student_no in ('STUDENT1234','STUDENT5678')</strong></p>
  
  <p>I got error like:
  <strong>java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB</strong> </p>
  
  <p>Any Idea how to resolve this Error?</p>