Oracle NLS Parameters Viewer
Displays National Language Support (NLS) settings at the database, instance, and session levels. Useful for checking language, territory, date format, character set, and localization settings in Oracle.
oraclesqlmonitoring-alertsv1.0.0
0 stars0 downloads17 views0 comments
By OracleDba • Created
Code
(20 lines)1234567891011121314151617181920
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/nls_params.sql
-- Author : Tim Hall
-- Description : Displays National Language Suppport (NLS) information.
-- Requirements :
-- Call Syntax : @nls_params
-- Last Modified: 21-FEB-2005
-- -----------------------------------------------------------------------------------
SET LINESIZE 100
COLUMN parameter FORMAT A45
COLUMN value FORMAT A45
PROMPT *** Database parameters ***
SELECT * FROM nls_database_parameters ORDER BY 1;
PROMPT *** Instance parameters ***
SELECT * FROM nls_instance_parameters ORDER BY 1;
PROMPT *** Session parameters ***
SELECT * FROM nls_session_parameters ORDER BY 1;