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

5 votes151 views1 answer
Oracle ORA-00054 origin
SQL
1 vote180 views1 answer
Limit offset order by mysql
SQL
8 votes157 views1 answer
Oracle create datafile
SQL
0 vote169 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote158 views1 answer
Alter table add check constraint oracle
SQL
0 vote185 views1 answer
Oracle list user locked
SQL
5 votes172 views1 answer
Oracle list days between two dates
SQL
1 vote148 views3 answers
Union in sql
SQL
10 votes167 views2 answers
Rtrim sql
SQL
0 vote185 views1 answer
Compress sql file database ubuntu
SQL