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: Sort of numbers and letters

Re: Sort of numbers and letters

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 10 Feb 2004 08:31:07 GMT
Message-ID: <c0a4sa$143cl5$1@ID-82536.news.uni-berlin.de>

> Hi there!
>
> I want oracle to sort in a way that numbers will be sorted before
> letters (ascending). For example: 1 < 10 < 2 < 3 < a < b < c . Therefore
> I found that NLS_SORT has to be set to BINARY. Unfortunately I also want
> german umlauts (,,) to be treated as "ae", "oe" and "ue" or at least
> inserted to their best corrosponding ( to a, to o, ...). For this I
> have to change NLS_SORT to GERMAN. But then the numbers are at the end
> of the list.
> In my case a sorted list should look like this:
> 1
> 10
> 2
> 3
> a
>
> b
> b1
> b10
> c
>
> Is there a chance to teach oracle this behaviour?
>
> Thanks in advance!
> Florian

Oracle Locale Builder might help you. I am not sure as I haven't tried it. Find the details at:

download-west.oracle.com/docs/cd/B10501_01/server.920/a96529/ch12.htm#1008740

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch
Received on Tue Feb 10 2004 - 02:31:07 CST

Original text of this message

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