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