Re: Sort of numbers and letters

> 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