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));