Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> CLOB in select?
Hi,
i am having a table, where long text is stored in a CLOB-field. When i am sending the query like:
select * from Scott.TEST WHERE xml_doc LIKE 'test' ;
i am getting the error ORA-00932.
The oracle-reference is describing, that LONG-datatypes cannot be used in
the where-clause. Is it the same with CLOB-datatype?
Thanks in advance, Michael Received on Wed Sep 19 2001 - 08:40:06 CDT