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

4 votes122 views1 answer
Oracle show errors
SQL
3 votes110 views2 answers
Mysql time
SQL
0 vote126 views2 answers
Change database postgres
SQL
6 votes114 views3 answers
Commit in sql
SQL
0 vote108 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote143 views1 answer
Mysqldump: error:
SQL
8 votes187 views1 answer
Oracle search code in packages
SQL
7 votes124 views2 answers
Mysql check db size
SQL
0 vote117 views1 answer
Python list from sql
SQL
0 vote72 views1 answer
Check sql query executed wp
SQL