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 vote351 views1 answer
Drop primary key oracle
SQL
0 vote367 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote313 views1 answer
Flask sqlalchemy decimal
SQL
0 vote340 views1 answer
Search In the Database using Text
SQL
3 votes314 views1 answer
Oracle apex warning message
SQL
-1 vote312 views1 answer
How to open blade file from blade in laravel
SQL
22 votes333 views3 answers
SQL CHEATSHEET
SQL
5 votes323 views1 answer
Oracle generate list of dates in between a date range
SQL
1 vote345 views1 answer
Insert value to new table by joining 2 different tables
SQL
3 votes331 views2 answers
Find string in stored procedure sql server
SQL