Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Text Search Problem
if you have oracle 7.... then you can make one column more and write here upperca se values
"Atta ur-Rehman" <atta707_at_my-deja.com> wrote in message
news:8an8v3$qu$1_at_nnrp1.deja.com...
> hi,
>
> if you're in oracle 8.1+, then you might want to have a look at
> 'function based' indexes.
>
> :) ATTA
>
>
> In article <01bf8d3f$3f7dd350$dc000001_at_iwserver>,
> "Fernando" <Info_at_entelchile.net> wrote:
> > I want to search over upper and lower case text indexed columns.
> >
> > Haw can I do this using the index and avoiding the complete table
search
> > that generates "WHERE UPPER(COLUMN) = 'ABCD'"
> >
> > Thanks
> >
> > Fernando Seelmann
> >
> --
> getting the meanin' of data...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 15 2000 - 00:00:00 CST