ITPub博客

首页 > Linux操作系统 > Linux操作系统 > NLS_SORT(转)

NLS_SORT(转)

原创 Linux操作系统 作者:tochar 时间:2007-07-27 00:00:00 0 删除 编辑

NLS_SORT

Parameter type

String

Syntax

NLS_SORT = {BINARY | linguistic_definition}

Default value

Derived from NLS_LANGUAGE

Parameter class

Dynamic: ALTER SESSION

Range of values

BINARY or any valid linguistic definition name

NLS_SORT specifies the collating sequence for ORDER BY queries.

  • If the value is BINARY, then the collating sequence for ORDER BY queries is based on the numeric value of characters (a binary sort that requires less system overhead).
  • If the value is a named linguistic sort, sorting is based on the order of the defined linguistic sort. Most (but not all) languages supported by the NLS_LANGUAGE parameter also support a linguistic sort with the same name.


    Note:

    Setting NLS_SORT to anything other than BINARY causes a sort to use a full table scan, regardless of the path chosen by the optimizer. BINARY is the exception because indexes are built according to a binary order of keys. Thus the optimizer can use an index to satisfy the ORDER BY clause when NLS_SORT is set to BINARY. If NLS_SORT is set to any linguistic sort, the optimizer must include a full table scan and a full sort in the execution plan.



昨天同事用了我的机子,今天不知道怎么了,控制面板里打开服务后,想启动我的数据库服务,但是出错了:
“无法从本地计算机启动OracleServiceTEST000R服务
错误号:5,拒绝访问。”
我试了其他ORACLE服务,不论是要启动还是要停止,均是同样的错误。
是不是系统问题呀。
请各位支着,在下感激不禁。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45121/,如需转载,请注明出处,否则将追究法律责任。

下一篇: NLS_TERRITORY(转)
请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    787480