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 vote132 views2 answers
How to display top 50 rows?
SQL
0 vote144 views1 answer
Mssql check if date is greater than today
SQL
10 votes168 views6 answers
Mysql set root password
SQL
6 votes149 views2 answers
Insert into select mysql
SQL
3 votes204 views2 answers
Oracle privileges users
SQL
1 vote166 views1 answer
Sql in array query
SQL
0 vote132 views1 answer
Timestamp(0) postgresql
SQL
0 vote148 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote131 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote101 views2 answers
Last working day in week date function in sql
SQL