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
A、NLS_LANG
B、NLS_COMP
C、NLS_SORT
D、None of the above
A、V$VALID_NLS_VALUES B、NLS_VALID_VALUES C、NLS_VALUE_OPTIONS D、V$NLS_VALUE_OPTIONS E、V$NLS_VALID_VALUES
A、A. V$VALID_NLS_VALUES B、B. NLS_VALID_VALUES C、C. NLS_VALUE_OPTIONS D、D. V$NLS_VALUE_OPTIONS E、E. V$NLS_VALID_VALUES
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.
A、WHERE clause WHERE B、ORDER BY clause C、BETWEEN clause D、NLSSORT function E、NLS_SORT function
A、A. NLS_SORT = BINARY B、B. NLS_SORT = BINARY_AI C、C. NLS_SORT = BINARY_CI D、D. NLS_SORT = BINARY_AI_CI E、E. Binary sorts are case insensitive and accent insensitive by default