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