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 vote220 views1 answer
Oracle procedure chain step
SQL
2 votes227 views2 answers
Useradd postgres
SQL
1 vote226 views2 answers
Find a column in all tables mysql
SQL
0 vote209 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote244 views3 answers
Constraint sql
SQL
0 vote253 views1 answer
Trigger vérifier stock
SQL
1 vote251 views2 answers
Drop table with constraints
SQL
0 vote241 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
3 votes219 views1 answer
Oracle revoke
SQL
0 vote224 views1 answer
Mysql use password error
SQL