ITPub博客

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

NLS_COMP(转)

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

NLS_COMP

Parameter type

String

Syntax

NLS_COMP = {BINARY | ANSI}

Default value

BINARY

Parameter class

Dynamic: ALTER SESSION

Normally, comparisons in the WHERE clause and in PL/SQL blocks is binary unless you specify the NLSSORT function. By setting NLS_COMP to ANSI, you indicate that comparisons in the WHERE clause and in PL/SQL blocks should use the linguistic sort specified in the NLS_SORT parameter. You must also define an index on the column for which you want linguistic sorts.


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

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

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    790637