Case Insensitive searches
From: Craig Burkett <cburkett_at_triad.rr.com>
Date: Fri, 23 May 2003 16:40:12 GMT
Message-ID: <M9sza.45556$Lm2.3596837_at_twister.southeast.rr.com>
[Quoted] Hi all,
Date: Fri, 23 May 2003 16:40:12 GMT
Message-ID: <M9sza.45556$Lm2.3596837_at_twister.southeast.rr.com>
[Quoted] 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,
-- Craig BurkettReceived on Fri May 23 2003 - 18:40:12 CEST