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

0 vote177 views1 answer
Oracle index hint multiple tables example
SQL
8 votes199 views1 answer
Oracle search code in packages
SQL
12 votes190 views1 answer
Psql drop column
SQL
0 vote199 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
9 votes197 views4 answers
How to create new user and database postgresql in ubuntu
SQL
-1 vote214 views2 answers
Installing mysql on centos 7
SQL
0 vote195 views2 answers
Sql 2 way of select unique
SQL
0 vote205 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
2 votes185 views1 answer
Oracle table size
SQL
0 vote181 views1 answer
How to find the most occuring in SQL
SQL