Re: Using LOBs in SQLPLUS

A copy of this was sent to clownofdoom_at_my-deja.com (if that email address didn't require changing) On Thu, 02 Dec 1999 06:09:09 GMT, you wrote:

>Hey Gang.
>
>I have a table with a CLOB in it. I'd like to
>know which rows include a certain string.
>Unfortunately, this doesn't work:
>
>select * from aTable where theClob like '%X%';
>

select * from aTable where dbms_lob.instr( theClob, 'X' ) > 0;

>I get an "ORA-00932: inconsistent datatypes"
>error. I'm using Oracle 8.5 on a Linux server.
>
>Thanks for any help!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 02 1999 - 06:45:05 CST