How can I do create an index on expression ?

From: <luba_at_usb>
Date: Tue, 23 Jan 2001 10:43:40 +0200
Message-ID: <94ju9e$5q0$1@news.ukrsotsbank.com>

How can I do create an index on upper(name) ?

Roy Brokvam <roy.brokvm_at_conax.com> ÓÏÏÂÝÉÌ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:Hf_a6.327$2i6.5014_at_news1.oke.nextra.no...
> Hi,
>
> select name from user where upper(name) = 'JOHN'
>
> If you need quick access via an index, create an index on upper(name)
> instead of name.

>
> --
> Roy Brokvam
>
> Hitchhikers against spam! Correct my last name to e-mail me.
>
>
> pluto wrote in message <94hbb7$5fbm$1_at_stargate1.inet.it>...
> >How i can make Oracle 8i case insensitive?
> >
> >Ex.:
> >select name from user where name = 'john'
> >
> >equal to
> >
> >select name from user where name = 'JOHN'
> >
> >Thancks
> >
> >
> >
>
>
Received on Tue Jan 23 2001 - 02:43:40 CST