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 vote174 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote241 views1 answer
Sql decimal to 2 places
SQL
2 votes312 views2 answers
MySql FULL OUTER JOIN
SQL
3 votes186 views2 answers
Postgres show table schema
SQL
0 vote195 views1 answer
Mysql url data type
SQL
0 vote201 views1 answer
How to to get time in sql
SQL
0 vote259 views2 answers
Fanyi
SQL
2 votes210 views3 answers
Postgres json to string
SQL
0 vote184 views1 answer
Sql server remove 0 from left
SQL
3 votes236 views2 answers
Wp do sql query from function
SQL