461.The NLS_SORT parameter sets the default sort method for which of the following operations?(Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
Answer: AD
国家语言支持排序参数设置默认的排序方式为以下哪些操作?
The NLS_SORT parameter defines the default sort method (binary or linguistic) for both SQL WHERE clause operations and NLSSORT function operations. The default sort method for ORDER BY and BETWEEN (and all other SQL operations that support linguistic sorts) is defined by the NLS_COMP parameter. NLS_SORT is an invalid function name.
NLS_SORT参数定义默认的排序方式(二进制或语言)是用于SQL WHERE子句操作和NLSSORT函数操作。
用于ORDER BY和BETWEEN(以及所有其他支持语言排序的SQL操作)的默认的排序方式由NLS_COMP参数定义。
NLS_SORT是一个无效函数名。
Oracle默认是采用binary进行排序,这对于例如中文的排序来说,是不恰当的。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2124206/
,如需转载,请注明出处,否则将追究法律责任。