Re: Case Insensitive searches

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 - 12:32:41 CDT