拼音
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')
ORACLE知识点(六):Oracle常用的排序方式
最新推荐文章于 2023-04-06 21:05:24 发布