Find Out what NLS settings are in place
--
-- Find Out what NLS settings are in place
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF
 
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))
/

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License