Re: Change sorting behaviour?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 26 Apr 2002 07:10:56 +0200
Message-ID: <29ohcu8rh8qqtko7t4ainle67oj36trj6t@4ax.com>

On Thu, 25 Apr 2002 19:23:23 +0200, Andreas Koch <mail_at_kochandreas.com> wrote:

>Hi,
>
>is there a way to make oracle sort a varchar column in Format TextNumber
>(e.g. Example01, Data42, etc) allways as "Text as Text and
>Number as Number" ?
>(e.g
>Data1
>Data2
>Data9
>Data10
>Error1
>Error5
>
>instead of
>
>Data1
>Data10
>Data2
>Data9
>Error1
>Error5
>)
>
>If this can't be done per connection, what would be the best
>way to modify a SQL to sort this way?

alter session set nls_sort = <something else than the default binary> v$nls_valid_values will show your options. Please disregard the other advice.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Apr 26 2002 - 00:10:56 CDT