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 vote226 views1 answer
Test sql query
SQL
0 vote219 views1 answer
Mysql get last 2 month data
SQL
0 vote205 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote215 views1 answer
Merge clause with inner join
SQL
0 vote242 views1 answer
Check constraint is violated
SQL
3 votes213 views2 answers
Pl sql escape '
SQL
42 votes247 views6 answers
Sql query duplicate rows
SQL
0 vote231 views1 answer
Report in database
SQL
0 vote233 views1 answer
Firebase sql
SQL
0 vote219 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL