Re: Searching CLOBS case insensitive

From: John Russell <netnews4_at_johnrussell.mailshell.com>
Date: Fri, 20 Dec 2002 05:49:49 GMT
Message-ID: <rkb50v4sn3ue9tjokp0ivim5t8at3cd33j@4ax.com>

On 19 Dec 2002 06:12:09 -0800, Petri33_at_hotmail.com (Petri) wrote:

>Pablo Sanchez <pablo_at_dev.null> wrote in message news:<Xns92E892FD6AB37pingottpingottbah_at_209.242.64.107>...
>> Petri33_at_hotmail.com (Petri) wrote in
>> news:b4803f2d.0212181312.2dcc4fde_at_posting.google.com:
>>
>> > I am trying to search a CLOB field case insensitively. I am
>> > currently using dbms_lob.instr() but this function is case
>> > sensitive. Does anyone know how to search case insensitively?
>>
>> Unless you plan on having very few CLOB searches, you might want to
>> instead use the Intermedia/Context cartridge to do this activity.
>
>How would I use the Intermedia/Context cartridge? Do you know where I
>could find an example?

These days it's known as Oracle Text. You create a special kind of index, then you use the CONTAINS( ) function in the query to check for the existence of words, phrases, boolean expressions, etc.

Here are the manuals (App Dev Guide and Reference):

http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage#index-TEX

John Received on Thu Dec 19 2002 - 23:49:49 CST