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

1 vote355 views1 answer
Postgresql contains
SQL
0 vote396 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote374 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote428 views1 answer
Get substract count sql
SQL
0 vote378 views1 answer
How to add session data into mysql database from button
SQL
25 votes450 views5 answers
Mysql replace text
SQL
0 vote329 views1 answer
How to check replication lag in mySQL
SQL
4 votes375 views2 answers
Dbms output
SQL
0 vote341 views1 answer
Selects all the columns from the sailors table
SQL
15 votes341 views2 answers
How to know the username of postgresql
SQL