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

4 votes208 views1 answer
Postgresql show current database
SQL
17 votes237 views6 answers
MySQL ORDER BY
SQL
0 vote243 views1 answer
Sql update subtract value
SQL
7 votes247 views1 answer
Oracle pagination query rownum
SQL
5 votes251 views4 answers
Traduction
SQL
0 vote229 views1 answer
Mysql url data type
SQL
0 vote226 views1 answer
Find all tables where column name exists oracle
SQL
23 votes239 views2 answers
Query to delete a database in mysql
SQL
0 vote231 views1 answer
Oracle sql number to varchar2
SQL
0 vote245 views1 answer
Sqlite insert or update
SQL