Re: Case Insensitive searches

2 mins in the docs gave me this - next time you try it

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/data_acc.htm#2185

"M" <someone_at_microsoft.com> wrote in message news:balmuu$2psi$1_at_news.hgc.com.hk...
> Could you elaborate more on "function based indexes"? Thanks.
>
> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
> news:3mmscvs04u6ph9mqiv2j342mb7r35fb09n_at_4ax.com...
> > On Fri, 23 May 2003 16:40:12 GMT, "Craig Burkett"
> > <cburkett_at_triad.rr.com> wrote:
> >
> > >Hi all,
> > >
> > >I need some guidance as to how best accomplish a case insensitive
search
> > >while still using indexes. One thing I was wondering was does PL/SQL
> > >support regular expressions and can they be applied to existing
indexes.
> > >I'm trying to avoid having to rebuild indexes forcing them to using
upper
> > >case and I certainly don't want a function (ie UPPER) on the field side
> of
> > >the equation which would cause a table scan instead of an index search.
> > >
> > >Also does anyone know if Oracle 9i support a switch to use case
> insensitive
> > >comparisons?
> > >
> > >Thanks,
> >
> >
> > Use function based indexes (available in EE only), or add a redundant
> > column, indexed
> >
> > Why would Oracle 9i support case insensitive comparisons if there are
> > function based indexes, and the world outside the Evil Empire (also
> > known as Mickeysoft) didn't change to case insensitive.
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Fri May 23 2003 - 13:08:05 CDT