Oracle get nls settings

SELECT *
FROM (SELECT 'SESSION' SCOPE, nsp.* FROM NLS_SESSION_PARAMETERS nsp
      UNION ALL
      SELECT 'DATABASE' SCOPE, ndp.* FROM NLS_DATABASE_PARAMETERS ndp
      UNION ALL
      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));
-- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Similar codes

0 vote245 views1 answer
Mysql where in maintain order
SQL
1 vote252 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote241 views1 answer
Mysql 8 error on identified by
SQL
0 vote234 views1 answer
How to create a new shema using query languaage
SQL
62 votes262 views8 answers
Mysql add column
SQL
1 vote226 views1 answer
List index mysql cli
SQL
0 vote253 views1 answer
How to check database engine in mysql
SQL
0 vote289 views1 answer
Mysql, how to query the table comments?
SQL
0 vote239 views3 answers
Database restoring error
SQL
0 vote239 views1 answer
Alter rename command in mysql
SQL