Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Searching CLOBS case insensitive

Re: Searching CLOBS case insensitive

From: Petri <Petri33_at_hotmail.com>
Date: 19 Dec 2002 06:12:09 -0800
Message-ID: <b4803f2d.0212190612.26153ce4@posting.google.com>


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? Received on Thu Dec 19 2002 - 08:12:09 CST

Original text of this message

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