Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> CLOB in select?

CLOB in select?

From: Michael Remme <remme_at_java-beans.de>
Date: Wed, 19 Sep 2001 15:40:06 +0200
Message-ID: <9oa766$r0s$00$1@news.t-online.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US