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

-1 vote120 views1 answer
How to use update trigger in sql
SQL
9 votes139 views5 answers
Sql delete duplicate rows but keep one
SQL
9 votes124 views1 answer
Sql server get utc date
SQL
-1 vote129 views3 answers
SQL to LINQ converter
SQL
5 votes121 views3 answers
Sql max value in column
SQL
4 votes135 views1 answer
Oracle show errors
SQL
2 votes183 views5 answers
Install postgresql 10 centos 7
SQL
1 vote125 views1 answer
Mysql query where in select
SQL
0 vote117 views1 answer
Change database name psql 8
SQL
11 votes123 views3 answers
How to get last row of table in sql
SQL