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
which of the following operations?
The NLS_SORT parameter sets the default sort method for which of the following
operations? (Choose all that apply.)
It doesn’t make sense:
select * from table_accent;
Finsteraarhornhutte
Grünhornlücke
einschließlich
finsteraarhornhütte
grünhornlücke
alter session set nls_sort=GERMAN;
select * from table_accent
where col1 > ‘einschließlich’;
finsteraarhornhütte
grünhornlücke
alter session set nls_sort=BINARY;
select * from table_accent
where col1 > ‘einschließlich’;
finsteraarhornhütte
grünhornlücke
===========> The NLS_SORT doesn’t seem to change the where behavior.
———————————————
alter session set nls_sort=GERMAN;
select * from table_accent
where nlssort(col1) > nlssort(‘einschließlich’);
Finsteraarhornhutte
Grünhornlücke
finsteraarhornhütte
grünhornlücke
alter session set nls_sort=BINARY;
select * from table_accent
where nlssort(col1) > nlssort(‘einschließlich’);
finsteraarhornhütte
grünhornlücke
===================> The NLS_SORT parameter changes the NLSSORT function behavior.
alter session set nls_sort=GERMAN;
select * from table_accent order by col1;
einschließlich
finsteraarhornhütte
Finsteraarhornhutte
grünhornlücke
Grünhornlücke
alter session set nls_sort=BINARY;
select * from table_accent order by col1;
Finsteraarhornhutte
Grünhornlücke
einschließlich
finsteraarhornhütte
grünhornlücke
=====================> The NLS_SORT parameter changes the order by behavior.
Tests realized on Oracle database version 11.2.0.4.0
So, I really don’t understand the answer to the question…
Correct answer should be B and D. The NLS_SORT parameter overrides the default sorting method for ORDER BY
operations and for the NLSSORT function, but it has no effect on other sort operations, such
as WHERE conditions. Therefore, this query ignored the parameter entirely.