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

0 vote143 views1 answer
Kill thread
SQL
0 vote132 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote248 views1 answer
How to use select union and loop
SQL
15 votes184 views6 answers
Drop foreign key mysql
SQL
4 votes148 views3 answers
Sqlite show columns
SQL
2 votes145 views2 answers
Sql percentage
SQL
2 votes138 views2 answers
Join update query in sql
SQL
0 vote149 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote168 views1 answer
Nvl postgres
SQL
0 vote138 views1 answer
Changer un mot de passe mysql
SQL