Oracle nls parameters

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

4 votes119 views1 answer
Group by mysql and concatenate string
SQL
0 vote68 views1 answer
Mysql select top 2
SQL
1 vote113 views3 answers
Drop unique key constraint in sql server
SQL
3 votes107 views1 answer
Oracle undo tablespace list by user
SQL
0 vote107 views1 answer
Object Information
SQL
1 vote103 views1 answer
Base nosql
SQL
0 vote116 views1 answer
Postgresql not in alternative
SQL
10 votes112 views1 answer
Oracle dba_dependencies
SQL
0 vote100 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote118 views1 answer
Oracle check table lock
SQL