Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Case insensitive select statement?

Re: Case insensitive select statement?

From: Mads S. Larsen <mads_at_syrak.dknospam>
Date: Thu, 31 Aug 2000 23:19:02 GMT
Message-ID: <GJBr5.6132$uy1.101655@news000.worldonline.dk>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US