Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Change sorting behaviour?
And which one works of the 500 or so should he try first.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:29ohcu8rh8qqtko7t4ainle67oj36trj6t_at_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 - 18:00:29 CDT