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

1 vote163 views1 answer
Mysql return text after a final full stop
SQL
0 vote153 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
8 votes147 views1 answer
Script to add datafile to tablespace
SQL
0 vote135 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote134 views1 answer
Sql create text column limited values
SQL
-1 vote192 views1 answer
Minus vs except in sql
SQL
0 vote128 views1 answer
How to connect pgadmin with excel
SQL
0 vote135 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote145 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote151 views1 answer
Into operator in sql
SQL