Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Case insensitive select statement?
> create index myindex on table1 (LOWER(name))
>
> However, Oracle8i Personal (Win98) reports that an index in a function
isn't
> supported. Perhaps this is a restriction of the Personal edition?
>
Could be.. There is always the old "shadow column" approach: Add an extra
column to store an uppercase version of the text to be searched.
B Rgds
Mads
Received on Thu Aug 31 2000 - 18:19:02 CDT