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

18 votes156 views3 answers
Get the list of all tables in sql server
SQL
16 votes150 views1 answer
Mysql smallint range
SQL
0 vote132 views1 answer
How to select only id where is not in column mysql
SQL
0 vote147 views1 answer
Least spark sql
SQL
2 votes137 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote169 views1 answer
Sql count matching group by
SQL
0 vote132 views1 answer
Set column in all row mysql
SQL
8 votes130 views3 answers
Alter user root mysql
SQL
3 votes137 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote145 views1 answer
Drop database using terminal postgres
SQL