Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Case Insensitive searches
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 - 11:40:12 CDT
![]() |
![]() |