按拼音(默认): alter session set nls_sort = SCHINESE_PINYIN_M;
按笔画:alter session set nls_sort = SCHINESE_STROKE_M;
按偏旁:alter session set nls_sort =SCHINESE_RADICAL_M;
举例:
name字段为中文
//按照拼音排序
SELECT t.* FORM T_SYS_DIC t ORDER BY nlssort(t.name,'NLS_SORT=SCHINESE_PINYIN_M');