Oracle nls session

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 vote235 views2 answers
Dumping sql table
SQL
0 vote223 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote226 views1 answer
Apex for oracle 11g
SQL
0 vote307 views2 answers
Sqlalchemy default value for column
SQL
0 vote209 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote232 views1 answer
Mysql where don't have string
SQL
1 vote208 views1 answer
Nested if in mysql
SQL
0 vote218 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote236 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
13 votes229 views2 answers
Sql online compiler
SQL