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

49 votes261 views6 answers
Install mysql ubuntu
SQL
0 vote160 views2 answers
Generate sql trigger through ef migration
SQL
0 vote151 views2 answers
Functions with parameters SQL
SQL
0 vote155 views1 answer
How to find columns with null values in sql
SQL
3 votes161 views1 answer
Oracle apex call duration
SQL
1 vote283 views2 answers
Postgres select from last 3 months
SQL
-1 vote146 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
2 votes146 views1 answer
Oracle cpu per session
SQL
0 vote154 views1 answer
Sql period overlap
SQL
5 votes147 views2 answers
Sql number columns
SQL