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 vote343 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote390 views1 answer
Mysql select from outside
SQL
0 vote397 views1 answer
Postgresql print sessions using the database
SQL
1 vote373 views1 answer
Sql where last 12 months
SQL
0 vote359 views1 answer
How get data from database if id not found then search another column
SQL
5 votes374 views1 answer
Mysql created at yesterdau
SQL
0 vote352 views1 answer
Oracle synonym procedure dblink
SQL
3 votes363 views1 answer
Oracle function return
SQL
0 vote353 views1 answer
Insert array into mysql column
SQL
1 vote395 views1 answer
Homebrew install mysql
SQL