关于053第470题

最新推荐文章于 2021-09-22 16:10:35 发布

聆雨落

最新推荐文章于 2021-09-22 16:10:35 发布

阅读量829

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/adeline_pan/article/details/46693937

版权

oracle 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

470.Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic
for the SQL SELECT statement?
A. NLS_LANG
B. NLS_COMP
C. NLS_SORT
D. None of the above
Answer: D

个人认为应该选B

参考：

Linguistic comparison is useful if the binary sequence of numeric codes does not match the linguistic sequence of the characters you are comparing. Linguistic comparison is used if the NLS_SORT parameter has a setting other than BINARY and the NLS_COMP parameter is set to LINGUISTIC. In linguistic sorting, all SQL sorting and comparison are based on the linguistic rule specified by NLS_SORT.