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 -> Re: SQL Query- filter on text in CLOB

Re: SQL Query- filter on text in CLOB

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 23 Aug 2004 22:29:58 -0700
Message-ID: <1093325448.633139@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

-- 
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

Original text of this message

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