Oracle get nls settings

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 vote175 views1 answer
Count the table indatabase
SQL
0 vote180 views1 answer
Oracle decode
SQL
2 votes173 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote189 views1 answer
Why do we need data structure in sql
SQL
0 vote172 views1 answer
Sql database connectivity
SQL
12 votes198 views1 answer
Run mysql instance in docker
SQL
0 vote153 views1 answer
Show table structure mysql console
SQL
0 vote130 views1 answer
Select all domains of database firbird
SQL
0 vote126 views1 answer
Copy table dbeaver
SQL
13 votes171 views6 answers
Restart postgresql
SQL