Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Query- filter on text in CLOB
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
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Tue Aug 24 2004 - 00:29:58 CDT
![]() |
![]() |