Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Searching CLOBS case insensitive
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