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

1 vote187 views1 answer
Mysql tables max count
SQL
0 vote150 views2 answers
How to know the character set of an oracle databes
SQL
3 votes164 views1 answer
Mysql replace string in table
SQL
2 votes149 views2 answers
Oracle multiple insert
SQL
0 vote162 views1 answer
Show tables in cassandra cql
SQL
0 vote150 views1 answer
Mysql in clausule string array
SQL
0 vote158 views2 answers
Soql last year
SQL
0 vote169 views1 answer
Find how many tables in database sql query
SQL
1 vote143 views1 answer
Mysqli connect
SQL
3 votes152 views2 answers
How to load files in mysql
SQL