对于Oracle的NLSSORT进行简要概述,以备后用:
拼音: SELECT * FROM table ORDER BY NLSSORT(排序字段,‘NLS_SORT = SCHINESE_PINYIN_M’)
笔划: SELECT * FROM table ORDER BY NLSSORT(排序字段,‘NLS_SORT = SCHINESE_STROKE_M’)
部首 SELECT * FROM table ORDER BY NLSSORT(排序字段,‘NLS_SORT = SCHINESE_RADICAL_M’)