Re: Function Based Index in Oracle 8

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 10 Dec 1999 07:57:23 +0100
Message-ID: <82q8c7$2vh0o$1@fu-berlin.de>

The only thing I know is to have an additional column with the searchable string in uppercase and an index on it.

Bye
Uli

Anurag <anurag_at_synergy-infotech.com> schrieb in im Newsbeitrag: 0146ce5a.21c3b030_at_usw-ex0102-012.remarq.com...
> Hi,
> I want to make my text search case insensitive but sine the index wont
> be used if I use the upper() function. Is it possible to have function
> based index or any workaround in oracle 8. I know it is possible in 8i.
>
> Thanks
> Anurag
>
>
> also reply at
> anurag_at_synergy-infotech.com
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Dec 10 1999 - 00:57:23 CST