order by到底以什么规则排序的?
是以字段的ascii码吗?
因为我在适用cube分组时,order by的几个字段都是汉字的,那排序出来的 出来的数据很乱了.

我就是想问一下order by是以什么规则排序的？

order_by_clause

Use the ORDER BY clause to order rows returned by the statement. Without an order_by_clause, no guarantee exists that the same query executed more than once will retrieve rows in the same order.


SIBLINGS

The SIBLINGS keyword is valid only if you also specify the hierarchical_query_clause (CONNECT BY). ORDER SIBLINGS BY preserves any ordering specified in the hierarchical query clause and then applies the order_by_clause to the siblings of the hierarchy.


expr

expr orders rows based on their value for expr. The expression is based on columns in the select list or columns in the tables, views, or materialized views in the FROM clause.


position

Specify position to order rows based on their value for the expression in this position of the select list. The position value must be an integer.

You can specify multiple expressions in the order_by_clause. Oracle Database first sorts rows based on their values for the first expression. Rows with the same value for the first expression are then sorted based on their values for the second expression, and so on. the database sorts nulls following all others in ascending order and preceding all others in descending order. Please refer to "Sorting Query Results " for a discussion of ordering query results.


ASC | DESC

Specify whether the ordering sequence is ascending or descending. ASC is the default.


NULLS FIRST | NULLS LAST

Specify whether returned rows containing null values should appear first or last in the ordering sequence.

NULLS LAST is the default for ascending order, and NULLS FIRST is the default for descending order.

Restrictions on the ORDER BY Clause
The following restrictions apply to the ORDER BY clause:

If you have specified the DISTINCT operator in this statement, then this clause cannot refer to columns unless they appear in the select list.

An order_by_clause can contain no more than 255 expressions.

You cannot order by a LOB column, nested table, or varray.

If you specify a group_by_clause in the same statement, then this order_by_clause is restricted to the following expressions:

Constants

Aggregate functions

Analytic functions

The functions USER, UID, and SYSDATE

Expressions identical to those in the group_by_clause

Expressions comprising the preceding expressions that evaluate to the same value for all rows in a group.

在那个帖子中老狐狸如是说:
在oracle9i中新增了按照拼音、部首、笔画排序功能。设置NLS_SORT值
SCHINESE_RADICAL_M 按照部首（第一顺序）、笔划（第二顺序）排序
SCHINESE_STROKE_M 按照笔划（第一顺序）、部首（第二顺序）排序
SCHINESE_PINYIN_M 按照拼音排序，系统的默认排序方式为拼音排序

举例如下：
表名为 dept ，其中name字段是中文，下面分别实现按照单位名称的笔划、部首和拼音排序。
1: //按照笔划排序
2: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M');
3: //按照部首排序
4: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_RADICAL_M');
5: //按照拼音排序，此为系统的默认排序方式
6: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');

哦，谢谢

QUOTE:

---

原帖由 zhangweicai74 于 2008-6-25 17:13 发表
在那个帖子中老狐狸如是说:
在oracle9i中新增了按照拼音、部首、笔画排序功能。设置NLS_SORT值
SCHINESE_RADICAL_M 按照部首（第一顺序）、笔划（第二顺序）排序
SCHINESE_STROKE_M 按照笔划（第一顺序）、部首（第二顺序）排序
SCHINESE_PINYIN_M 按照拼音排序，系统的默认排序方式为拼音排序

举例如下：
表名为 dept ，其中name字段是中文，下面分别实现按照单位名称的笔划、部首和拼音排序。
1: //按照笔划排序
2: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_STROKE_M');
3: //按照部首排序
4: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_RADICAL_M');
5: //按照拼音排序，此为系统的默认排序方式
6: select * from dept order by nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');

---

，我不是原作的，不记得在哪里看到的，当时保留下来备查的

QUOTE:

---

原帖由 zhangfengh 于 2008-6-25 17:24 发表



，我不是原作的，不记得在哪里看到的，当时保留下来备查的

---

在老杨的个人空间里面，讲汉字拼音首字母的

QUOTE:

---

原帖由 zhangfengh 于 2008-6-25 17:24 发表



，我不是原作的，不记得在哪里看到的，当时保留下来备查的

---

拿来主义,为我所用就是我的

值得学习，我收藏了，呵呵