Re: WHERE clause ?

nougain_at_hotmail.com (javaq) wrote in message news:<e9af93aa.0110132357.1efb817c_at_posting.google.com>...
> CLOB field in sql 'WHERE clause' gives ORA-00932: inconsistent datatypes
> How to use CLOB fields in WHERE clause?
> ---------------------------------------
>
> create table t (id number, data clob);
>
> ...properly inserted number of records having clob data...
>
> select id from t where data like '%something%';
>
> The above gives ORA-00932: inconsistent datatypes
>
> How to use CLOB fields in WHERE clause?
>
> I am using Oracle8.1.6 Windows 2000 JDK1.3 JDBC Thin/OCI8 drivers
>
> --Many Thanks

This is not supported in 8i, it is supported in 9i You can use the dbms_lob.instr function to get similar functionality or the contains operator in Oracle Intermedia.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Mon Oct 15 2001 - 09:27:29 CEST