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 vote221 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote249 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote250 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
13 votes248 views4 answers
What is sql
SQL
0 vote224 views2 answers
Return the number of records in a single table mysql
SQL
8 votes231 views1 answer
Oracle create datafile
SQL
1 vote375 views2 answers
Sql unique rows
SQL
-1 vote227 views1 answer
Mysql extract days
SQL
0 vote218 views1 answer
Postgre admin slow
SQL
0 vote230 views1 answer
Connect laravel to mysql on mac
SQL