在oracle中设置NLS_SORT和NLS_COMP

Question

我试图为当前会话设置NLS_COMP和NLS_SORT，以检查它是否会对我正在运行的某些SQL查询(即区分大小写的查询)产生影响，由于某些原因，参数不会改变我做错了什么？

SELECT * FROM nls_database_parameters where parameter in ('NLS_COMP','NLS_SORT');
>>>    NLS_SORT BINARY
>>>    NLS_COMP BINARY

SELECT * FROM nls_instance_parameters where parameter in ('NLS_COMP','NLS_SORT');
>>>    NLS_SORT NULL
>>>    NLS_COMP BINARY

ALTER SESSION SET NLS_COMP=LINGUISTIC;
>>>session SET altered.
ALTER SESSION SET NLS_SORT=BINARY_CI;
>>>session SET altered.

SELECT * FROM nls_database_parameters where parameter in ('NLS_COMP','NLS_SORT');
>>>    NLS_SORT BINARY
>>>    NLS_COMP BINARY

SELECT * FROM nls_instance_parameters where parameter in     ('NLS_COMP','NLS_SORT');
>>>    NLS_SORT NULL
>>>    NLS_COMP BINARY

Answer 1

您正在设置会话值，但正在读取系统值。试着从NLS_SESSION_PARAMETERS阅读

SELECT *
FROM NLS_SESSION_PARAMETERS
WHERE PARAMETER IN ('NLS_COMP', 'NLS_SORT');