Re: Strange ORDER BY behaviour

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 30 Aug 2007 13:57:46 +0200
Message-ID: <46d6b0c7$0$238$e4fe514c@news.xs4all.nl>

<pascal.dulleck_at_veda.net> schreef in bericht news:1188474428.750682.221630_at_k79g2000hse.googlegroups.com...
> Wow, I was sure I had tried this before! But obviously not, because it
> worked!
> Thanks a lot, Carlos!
>

But still the (first) result is strange in some way: appearently, ORDER BY uses the NLS_SORT parameter, but '>' does not...

See

> AAA
> BBB
> CCC
> 222
> 333

with 111 left out when querying for > 200. The sort finds AAA, BBB, CCC less then 111, but the < operator does not....

Shakespeare Received on Thu Aug 30 2007 - 06:57:46 CDT