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

1 vote192 views1 answer
Jooq convert using gbk
SQL
0 vote236 views1 answer
Sql date with year
SQL
0 vote212 views1 answer
Microsoft sql server python connection
SQL
0 vote195 views1 answer
Psql no such file or directory
SQL
0 vote213 views1 answer
Utiliser sql ligne de commande
SQL
10 votes216 views2 answers
Sql pagination offset
SQL
0 vote206 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote196 views1 answer
Scaffold mysql database
SQL
0 vote203 views1 answer
Load utilities in sql server
SQL
1 vote225 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL