Blog / Database Blog

To get the NLS PARAMETER details

set linesize 150
set pagesize 1000
col name for a50
col parameter for a30
col value for a30
col member for a50
col DATAFILE_NAME for a70
col TEMPFILE_NAME for a70
col CONTROLFILE_NAME for a70
col LOGFILE_MEMBER for a70

select * from NLS_DATABASE_PARAMETERS;

Related blogs