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 vote201 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote205 views1 answer
Raiserror with nowait
SQL
1 vote187 views3 answers
Mariadb add foreign key
SQL
4 votes243 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote217 views1 answer
Drop table BigQuery table columns
SQL
3 votes202 views1 answer
Sql replace character in string in all records
SQL
0 vote199 views1 answer
Dbms_output sql developer
SQL
5 votes218 views1 answer
AND OR NOT operators sql
SQL
19 votes253 views1 answer
Sqrt(-1)
SQL
0 vote249 views1 answer
Mysql select row with min date
SQL