Oracle uses Nlssort functions to sort Chinese characters

1), sorted by pinyin first letter

SELECT * from T_table ORDER by Nlssort (NAME, ' nls_sort=schinese_pinyin_m ');

2), Sort by stroke
SELECT * from T_table ORDER by Nlssort (NAME, ' nls_sort=schinese_stroke_m ');

3), by radical sort
SELECT * from T_table ORDER by Nlssort (NAME, ' nls_sort=schinese_radical_m ');

A more detailed article address: http://www.2cto.com/database/201203/125387.html

Oracle uses Nlssort functions to sort Chinese characters