Oracle nls instance

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

2 votes138 views1 answer
Sql float to int
SQL
0 vote229 views1 answer
How to input data as id in database sql c#
SQL
7 votes186 views2 answers
Create mysql user
SQL
0 vote223 views1 answer
ALV GRID events
SQL
1 vote184 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote195 views1 answer
Less than date query sqlachemy
SQL
5 votes175 views1 answer
How to check nls timestamp format in oracle
SQL
4 votes210 views3 answers
Mysql get column names from table
SQL
0 vote174 views1 answer
Commit transaction sql
SQL
0 vote184 views2 answers
Temp tables in sql server
SQL