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

1 vote326 views1 answer
Postgres power
SQL
0 vote316 views1 answer
How to export only procedures mysql
SQL
1 vote277 views1 answer
Alter user mysql native password
SQL
29 votes308 views6 answers
Delete all rows from table mysql
SQL
0 vote306 views1 answer
Mysql date time string format python
SQL
1 vote315 views1 answer
Oracle duration between timestamps
SQL
0 vote354 views1 answer
Sql constarint
SQL
0 vote311 views1 answer
Foreign key multiple columns
SQL
1 vote340 views1 answer
Print all records of table in mysql
SQL
3 votes359 views1 answer
What is having
SQL