Check NLS Parameter and difference between Session and Database NLS parameter

Check NLS Parameter and difference between Session and database NLS parameter

Check session level NLS Parameter

col parameter for a25
col value for a30
Select * from nls_session_parameters;

Check Database level NLS Parameters

col parameter for a25
col value for a30
Select * from nls_database_parameters;

Check Instance level NLS Parameters

col parameter for a25
col value for a30
Select * from nls_instance_parameters;

Compare difference setting of NLS Parameter for Session, Database and Instance level

set line 200 pages 200
col "SESSION" format a30
col DATABASE format a30
col INSTANCE format a30
select * from
(select 'SESSION' SCOPE,nsp.* from nls_session_parameters nsp
union
select 'DATABASE' SCOPE,ndp.* from nls_database_parameters ndp
union
select 'INSTANCE' SCOPE,nip.* from nls_instance_parameters nip
) a
pivot (LISTAGG(VALUE) WITHIN GROUP (ORDER BY SCOPE)
FOR SCOPE
in ('SESSION' as "SESSION",'DATABASE' as DATABASE,'INSTANCE' as INSTANCE));