-- ----------------------------------------------------------------------------------- -- File Name : http://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; PROMPT *** Instance parameters *** SELECT * FROM nls_instance_parameters; PROMPT *** Session parameters *** SELECT * FROM nls_session_parameters;