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

17 votes342 views5 answers
Order by sql
SQL
0 vote363 views1 answer
Ubuntu connect to mssql database
SQL
1 vote388 views1 answer
Sql how to replace full stop
SQL
0 vote368 views1 answer
Postgres clear table
SQL
1 vote360 views1 answer
Float precision in psql
SQL
1 vote367 views2 answers
Sql now - 1 day
SQL
0 vote346 views1 answer
Pl/sql loop example
SQL
0 vote391 views1 answer
Drop tables from local database postgres pgadmin
SQL
9 votes347 views3 answers
Sequence postgresql
SQL
24 votes413 views6 answers
Sql change table name
SQL