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 vote354 views1 answer
How to drop a trigger in postgresql
SQL
1 vote399 views1 answer
Nullif postgresql
SQL
0 vote365 views1 answer
Rollback to name in sql
SQL
0 vote346 views1 answer
Provera dupliranih konatakata
SQL
1 vote355 views1 answer
How to delete a record from sqlite in android
SQL
2 votes356 views1 answer
Oracle find unusable indexes
SQL
51 votes461 views6 answers
Change column name sql
SQL
5 votes367 views5 answers
Sqlite install python
SQL
14 votes437 views1 answer
How to export db from mysql
SQL
1 vote358 views1 answer
Mysql backup skip table
SQL