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

0 vote170 views1 answer
Json_remove mysql
SQL
12 votes187 views4 answers
Mysql version query
SQL
0 vote185 views4 answers
Stored procedure sql
SQL
0 vote185 views1 answer
Change magento database url usimg musql
SQL
0 vote185 views3 answers
Insert query in ci
SQL
0 vote172 views1 answer
Get db connection detail from sql developer profile
SQL
2 votes196 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
8 votes182 views2 answers
Alert table name mysql
SQL
2 votes243 views5 answers
Tablespace ORACLE
SQL
0 vote192 views1 answer
Ubuntu stop mysql from starting on boot
SQL