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
Use the share button below if you liked it.
It makes me smile, when I see it.