Re: Oracle Sort

Fredy Tschui wrote:
> How can i change the sort "type" in oracle 8i ?
>
> Currently (special charachters are ignored)
> "a", "b", "(c", "d", "(e"
>
> but i need this:
> "(c", "(e", "a", "b", "d"
>

Fredy,
there are basicly two options:

If you just need this order in one SQL, you could do the following:

select my_column from my_table
order by nlssort(my_column,'nls_sort=BINARY');

If you generally need this for a single session, you would do:

alter session set nls_sort=BINARY;

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de