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
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?
Which NLS parameter can be used to change the default Oracle sort method from binary to
linguistic for the SQL SELECT statement?
I read
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch5lingsort.htm#i1008187
and
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch3globenv.htm#autoId42
NLS_SORT
Range of values – BINARY or any valid linguistic sort name
Example: SELECT * FROM test2 ORDER BY NLSSORT(name, ‘NLS_SORT=german’);
So NLS_SORT is used to set the sort method. By default it is binary.
NLS_SORT specifies the collating sequence for ORDER BY queries.
If the value is BINARY, then the collating sequence for ORDER BY queries is based on the numeric value of characters (a binary sort that requires less system overhead).
If the value is a named linguistic sort, sorting is based on the order of the defined linguistic sort. Most (but not all) languages supported by the NLS_LANGUAGE parameter also support a linguistic sort with the same name.
Note:
Setting NLS_SORT to anything other than BINARY causes a sort to use a full table scan, regardless of the path chosen by the optimizer. BINARY is the exception because indexes are built according to a binary order of keys. Thus the optimizer can use an index to satisfy the ORDER BY clause when NLS_SORT is set to BINARY. If NLS_SORT is set to any linguistic sort, the optimizer must include a full table scan and a full sort in the execution plan.