Oracle Database Discussions

hi

i am using oracle 10gR2 on hpux

database character set is multilingual and NLS_SORT prameter is set to RUSSIAN

when i fireing a query in this database output of query is sotrted by first charater string and then numeric string..but user wants it to be sort by first numeric and then characters

so temorary i have altered the nls_sort parameter to BINARY and then ran a query so it has given me the desired output(firts numeric and than character string)

is there any other workaroud to get the output like first numeric and then character becoz i if i change it for the perticular sql session it wont affect the application level

i can change it using alter system set nls_sort=binary but i m not allowed to do this becoz this database is created for russiaan language

is there any other way that i can use in a perticular query to get the desired output.