Thanks. Understood now. :)
"David Sharples" <david.sharples3_at_ntlworld.com> wrote in message
news:cstza.11195$Mu3.219496_at_newsfep4-glfd.server.ntli.net...
> 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 Sat May 24 2003 - 00:25:38 CDT
