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

4 votes169 views1 answer
Oracle select first 10 rows
SQL
0 vote198 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote164 views1 answer
PostgreSQL types and C# types
SQL
2 votes152 views1 answer
Oracle sql drop column if exists
SQL
0 vote176 views1 answer
Horizontal join sqlite
SQL
0 vote190 views1 answer
To Create directory
SQL
1 vote172 views1 answer
Sql order by where condition
SQL
10 votes163 views4 answers
Primary key in sql
SQL
0 vote154 views1 answer
Get sum sqlite android
SQL
0 vote205 views1 answer
Truncate a table then insert data
SQL