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 vote146 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote175 views1 answer
Sqlite schema structure of a relational database
SQL
4 votes119 views2 answers
Truncate oracle
SQL
0 vote135 views1 answer
Sql server python connection
SQL
2 votes148 views1 answer
Oracle kill session by sql_id
SQL
53 votes298 views6 answers
Sql server alter column
SQL
18 votes124 views6 answers
Drop table if exists
SQL
0 vote123 views1 answer
Select from 3 tables one is empty
SQL
3 votes127 views2 answers
Create schema postgres
SQL
0 vote122 views1 answer
Dump only data
SQL