PLSQL - 针对汉字的特别ORDER方式

最新推荐文章于 2022-06-09 12:02:23 发布

写代码也要符合基本法

最新推荐文章于 2022-06-09 12:02:23 发布

阅读量737

点赞数

分类专栏： Oracle学习笔记文章标签： PLSQL NLSSORT 汉字排序

本文链接：https://blog.csdn.net/liouzch/article/details/83587841

版权

Oracle学习笔记专栏收录该内容

48 篇文章 5 订阅

订阅专栏

一、按部首排序例

SELECT f.full_name
  FROM per_all_people_f f
 WHERE f.effective_start_date <= SYSDATE
   AND nvl(f.effective_end_date, SYSDATE) >= SYSDATE
 ORDER BY nlssort(f.full_name, 'NLS_SORT=SCHINESE_RADICAL_M') DESC

二、按笔划排序例

SELECT f.full_name
  FROM per_all_people_f f
 WHERE f.effective_start_date <= SYSDATE
   AND nvl(f.effective_end_date, SYSDATE) >= SYSDATE
 ORDER BY nlssort(f.full_name, 'NLS_SORT=SCHINESE_STROKE_M') DESC

三、按拼音排序例

SELECT f.full_name
  FROM per_all_people_f f
 WHERE f.effective_start_date <= SYSDATE
   AND nvl(f.effective_end_date, SYSDATE) >= SYSDATE
 ORDER BY nlssort(f.full_name, 'NLS_SORT=SCHINESE_PINYIN_M') DESC