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 vote182 views1 answer
Soql more than today
SQL
0 vote227 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote182 views2 answers
Get all index postgres
SQL
1 vote186 views1 answer
Set mysql mode global query
SQL
10 votes256 views1 answer
Oracle all_dependencies
SQL
0 vote182 views1 answer
How to make case insensitive in sql
SQL
2 votes179 views1 answer
How to select first row of database sql
SQL
2 votes218 views3 answers
Oracle show column of table
SQL
1 vote184 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote182 views1 answer
Install mysql 8 linux
SQL