AnsweredAssumed Answered

nls_database_parameters vs nls_instance_parameters vs nls_session_parameters

Question asked by Izraelevitz-VZW on Nov 2, 2017
Latest reply on Nov 3, 2017 by nick_darlington

We have to set the following 5 parameters (NLS_COMP, NLS_DATE_FORMAT, NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY) do the values have to match across the different NLS Parameter sets?

 

From what I understand, the order of precedence from lower to higher is

   nls_database_parameters

   nls_instance_parameters

   nls_session_parameters

 

Thus the values in    nls_session_parameters are the values Clarity uses.  IF that is the case, does it matter what values the other sets have?

 

Outcomes