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

9 votes188 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote307 views1 answer
Setting default value for Boolean data type in SQL
SQL
4 votes268 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote205 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote194 views1 answer
Sql doesn't contain
SQL
1 vote181 views1 answer
Mysql best tutorial for beginners
SQL
0 vote181 views1 answer
How to check xampp mysql password
SQL
1 vote171 views1 answer
Postgresql export output table as a csv
SQL
1 vote183 views1 answer
Convert rows to string sql server
SQL
0 vote193 views1 answer
Increase speed of like queries postgres
SQL