053469

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.

  The _AI suffix implies that an accent-insensitive sort will be performed.Accent-insensitive sorts are also case insensitive by default.The _CI suffix implies that a case-insensitive sort will be performed,but it will not be accent insensitive.Specifying both suffixes(_AI_CI) is illegal.

原文地址:https://www.cnblogs.com/Babylon/p/7837683.html