Re: Text Search Problem

From: Atta ur-Rehman <atta707_at_my-deja.com>
Date: 2000/03/15
Message-ID: <8an8v3$qu$1@nnrp1.deja.com>#1/1

hi,

if you're in oracle 8.1+, then you might want to have a look at 'function based' indexes.

:) ATTA In article <01bf8d3f$3f7dd350$dc000001_at_iwserver>, "Fernando" <Info_at_entelchile.net> wrote:
> I want to search over upper and lower case text indexed columns.
>
> Haw can I do this using the index and avoiding the complete table
search
> that generates "WHERE UPPER(COLUMN) = 'ABCD'"
>
> Thanks
>
> Fernando Seelmann
>

--
getting the meanin' of data...


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Wed Mar 15 2000 - 00:00:00 CST