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

2 votes251 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote251 views1 answer
Sql server cannot create database diagram
SQL
0 vote261 views1 answer
Geopoint from json mysql function
SQL
4 votes206 views1 answer
And or sql order of operations
SQL
4 votes254 views1 answer
List tables sqlite
SQL
0 vote274 views1 answer
Sqlite trim
SQL
0 vote270 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote292 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote268 views2 answers
Dbms interview questions
SQL
2 votes252 views2 answers
Sql query to copy data from one column to another
SQL