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 vote294 views1 answer
How to see logical reads in sql server
SQL
3 votes294 views2 answers
Order by postgresql
SQL
0 vote273 views1 answer
Not equal to blank in mysql
SQL
2 votes279 views4 answers
2nd highest salary in mysql
SQL
9 votes292 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote261 views1 answer
Joins vs includes
SQL
-1 vote262 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote264 views1 answer
Mysql update privileges
SQL
0 vote301 views1 answer
PostgreSQL types and C# types
SQL
0 vote291 views1 answer
How to print some string in mysql
SQL