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 vote282 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote271 views1 answer
Can't connect to postgresql mac os
SQL
0 vote327 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
1 vote230 views2 answers
Get date from datetime postgresql
SQL
0 vote263 views1 answer
Oracle merge insert if not exists
SQL
0 vote259 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote263 views1 answer
Sql remove non numeric characters
SQL
0 vote269 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote315 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote264 views1 answer
Mariadb number format
SQL