Oracle NLS / National Language Suppport

The nls_database_parameters shows the values of the NLS parameters for the database. Oracle notes these differences between the parameters.

  • NLS_SESSION_PARAMETERS shows the NLS parameters and their values for the session that is querying the view. It does not show information about the character set.
  • NLS_INSTANCE_PARAMETERS shows the current NLS instance parameters that have been explicitly set and the values of the NLS instance parameters.
  • NLS_DATABASE_PARAMETERS shows the values of the NLS parameters for the database. The values are stored in the database.
SELECT * FROM nls_session_parameters ORDER BY 1;   
SELECT * FROM nls_instance_parameters ORDER BY 1;  
SELECT * FROM nls_database_parameters ORDER BY 1; 

The NLS_LANGUAGE and NLS_TERRITORY values in nls_database_parameters cannot be changed once the database has been created

References

dba-oracle
Oracle Blog