The New Home of Oracle-wiki.net
The New Home of Oracle-wiki.net
All things oracle...
All things oracle...
A website for IT Professionals involved with Oracle database.
--
-- 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))
/
Published on
Published 18th June 2025