[Solved] How do I sort the list from database automatically according to the language? [closed]

by


You can change the way Oracle sorts data by changing the NLS_SORT and NLS_COMP parameter for your session.

If you want to retrieve say french data, you can use the following:

ALTER SESSION SET nls_comp = Linguistic;
ALTER SESSION SET nls_sort = XFrench_AI;

select *
from my_table
where language_code="fr"
order by some_column;

Consequently if you want to retrieve german data, you use:

ALTER SESSION SET nls_comp = Linguistic;
ALTER SESSION SET nls_sort = XGerman_CI;

select *
from my_table
where language_code="de"
order by some_column;

More details can be found in the manual: http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm

solved How do I sort the list from database automatically according to the language? [closed]