Oracle nls instance

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

9 votes309 views5 answers
Sql limit
SQL
0 vote312 views1 answer
Provide hardcoded value in the mysql query
SQL
17 votes309 views6 answers
Current date in sql
SQL
0 vote304 views1 answer
Difference between 2 query results sql server
SQL
0 vote320 views1 answer
Insert or update sql query
SQL
0 vote276 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
25 votes309 views1 answer
Mysql grant all privileges to a user
SQL
3 votes293 views1 answer
Sql datetime as date
SQL
0 vote315 views1 answer
Mysql exception output
SQL
0 vote304 views1 answer
Mysql update even / odd rows
SQL