Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Query- filter on text in CLOB
yeah, sorry apparently I was smoking crack when I wrot ethe original message.
I got it to work by altering my test query:
select *
from tableA
where dbms_lob.instr(body, 'A')
to:
select *
from tableA
where dbms_lob.instr(body, 'A') > 0
So there you go.
thanks!
Don
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1093325448.633139_at_yasure>...
> D wrote:
> > How can I writ the simplest query to select all the IDs from a table
> > where a certain string is present in a CLOB field?
> >
> > I want to do a LIKE comparison, but that doesn't work. I looked at
> > dbms_lob.instr and dbms_lob.substr but neither seem to work right. I
> > tried to_char in the where clause, but I probably have the syntax
> > wrong.
> >
> > If anyone can point me to the absolute fastest way to write this query
> > let me know.
> >
> > thanks!
> >
> > Don
>
> InterMedia
Received on Wed Aug 25 2004 - 14:49:33 CDT