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 vote297 views0 answer
SQL
1 vote362 views1 answer
How to select random rows from a table
SQL
1 vote325 views1 answer
Python escape string for sql
SQL
0 vote363 views2 answers
Sql stored procedure for access frontend
SQL
0 vote377 views1 answer
Acutal month year
SQL
3 votes395 views3 answers
Update con select postgresql
SQL
0 vote338 views1 answer
Mysql disable query caching
SQL
1 vote419 views2 answers
Copy table in sql
SQL
8 votes343 views1 answer
How to remove tables from postgresql
SQL
0 vote364 views1 answer
Sql delimiter to columns
SQL