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 vote332 views1 answer
Get initial in sql
SQL
2 votes282 views3 answers
How to pass password mysql command line
SQL
0 vote291 views1 answer
Copy value from one column to another postgres
SQL
0 vote356 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote229 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote290 views1 answer
Ms sql database data size
SQL
14 votes317 views3 answers
How to add default constraint in mysql
SQL
3 votes291 views3 answers
Sql last week
SQL
0 vote244 views1 answer
Jooq finding lastest value in table
SQL
0 vote272 views1 answer
Resulting Query
SQL