How to check nls format in oracle

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

13 votes291 views1 answer
Views in sql
SQL
0 vote366 views1 answer
Sqlite display data in separated columns
SQL
6 votes273 views1 answer
Check Table Exists
SQL
0 vote259 views1 answer
Clone table structure mysql
SQL
11 votes298 views1 answer
Ddl view
SQL
2 votes274 views1 answer
Sql count having
SQL
7 votes275 views1 answer
Connect mysql docker
SQL
1 vote297 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote301 views1 answer
Offset in postgresql example
SQL
13 votes267 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL