Oracle nls parameters

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 vote156 views1 answer
Plpgsql if statement
SQL
0 vote137 views1 answer
Dump only schema
SQL
25 votes149 views3 answers
How to use a database to see tables mysql
SQL
25 votes155 views5 answers
Date in mysql
SQL
0 vote115 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote157 views1 answer
How to locate pg_hba.conf file
SQL
3 votes154 views1 answer
Sql cast to integer
SQL
1 vote197 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote230 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote223 views1 answer
How to show current database in mysql
SQL