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





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?