CLOB Question

From: Marc <mstaheli_at_mail.sdsu.edu>
Date: Wed, 29 Jan 2003 09:35:30 -0800
Message-ID: <b194np$kbo$1@gondor.sdsu.edu>

Oracle 8.1.7 / Sun Solaris / PLSQL Server Pages

I need to search a clob column for a matching character string. The query is built dynamically.

message is the CLOB column.
p_search is the string to be matched anywhere within message.

As it is right now, it works, but it is case-sensitive.

To make the search case-insensitive, I'd like to use something like UPPER, but this doesn't work here.

Any suggestions? Thanks.

........

query_string := query_string||' DBMS_LOB.INSTR(message,'''||p_search||''') > 0 ';
........

Marc Received on Wed Jan 29 2003 - 11:35:30 CST