--

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

/