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

1 vote215 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
10 votes220 views4 answers
Join with multiple conditions sql
SQL
1 vote230 views1 answer
Rows to comma separated values in mssql
SQL
0 vote223 views1 answer
Like date sql server not working
SQL
1 vote213 views1 answer
Mysql count multiple columns in one query
SQL
1 vote220 views1 answer
Tsql update datetime
SQL
0 vote216 views1 answer
Mysql procedure between two tables
SQL
0 vote209 views1 answer
Create new table pl sql
SQL
0 vote207 views1 answer
Sql server remove enter from string
SQL
-1 vote220 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL