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博客 ” ，链接：https://blog.itpub.net/9078678/viewspace-45111/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
NLS_CALENDAR(转)
下一篇：
NLS_CURRENCY(转)
请登录后发表评论
登录
全部评论
