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

0 vote204 views1 answer
Get server date mysql
SQL
0 vote200 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote186 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote203 views4 answers
User defined function sql
SQL
0 vote156 views1 answer
Connection error in mysql workbench
SQL
0 vote198 views1 answer
SQL authentication error
SQL
0 vote188 views1 answer
Execut sql python
SQL
0 vote233 views1 answer
Select count postgres double row count > 1
SQL
0 vote194 views1 answer
Add column to table with default value plsql
SQL
0 vote198 views2 answers
Mysql get routine parameter list
SQL