Re: Order methods

From: Stephan Langer <slanger_at_dixi-wc.de>
Date: Mon, 19 Feb 2001 08:32:32 +0100
Message-ID: <3A90CC10.82749480@dixi-wc.de>

Hi Renato,

it depends on the NLS_LANG - Parameter if numbers are sorted before or after letters (like even some functions do, e.g. weekday ). Think its somewhere in the NLS manuals but son't know exactly where.

hth
Stephan

Renato De Ficis schrieb:

> Hi,
> using this simply sql:
>
> SELECT A FROM B
> ORDER BY A
>
> are selected some record with this wrong order:
>
> A
> -------------------
> e
> r
> t
> 2
> 6
> 9
>
> This should be the correct order:
>
> 2
> 6
> 9
> e
> r
> t
>
> NOOO??!?!?
> Thanks for your precious help.
>
> --
> Posted from alpha.show.it [194.184.40.2]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Mon Feb 19 2001 - 01:32:32 CST