Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to "Case Insensitive"
One other solution --
use interMedia
>There are three solutions to this
>- use UPPER(columnname) = <expression>
> this will result in full table scans
>- create redundant columns with the UPPERcased contents of the mixed case
>columns and index them
>- In Oracle 8i, Enterprise Edition, use function-based indexes.
Received on Thu Aug 03 2000 - 00:00:00 CDT