1.按照拼音首字母的正序或倒序排序
1 SELECT 2 CREATOR_REALNAME 3 FROM 4 tableName 5 ORDER BY NLSSORT(CREATOR_REALNAME, ‘NLS_SORT = SCHINESE_PINYIN_M‘) desc
1.按照拼音首字母的正序或倒序排序
1 SELECT 2 CREATOR_REALNAME 3 FROM 4 tableName 5 ORDER BY NLSSORT(CREATOR_REALNAME, ‘NLS_SORT = SCHINESE_PINYIN_M‘) desc