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

Home -> Community -> Usenet -> c.d.o.misc -> Re: case-insensitive sort

Re: case-insensitive sort

From: Andrey Voronov <avoronov_at_diasoft.ru>
Date: Mon, 13 Jan 2003 14:13:16 +0300
Message-ID: <avu70a$2n7l$1@gavrilo.mtu.ru>


And Full Table Scan?

> select ... from mmm where ... order by upper(my_column) asc;
> That should work. Or did you mean a case insensitive select?
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can
figure
> it out.
> "Andrey Voronov" <avoronov_at_diasoft.ru> wrote in message
> news:avtmnj$23ib$1_at_gavrilo.mtu.ru...
> > How I can implement case-insensitive sort without use function-based
> index?
Received on Mon Jan 13 2003 - 05:13:16 CST

Original text of this message

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