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

6 votes188 views4 answers
Mysql get random row
SQL
0 vote196 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote196 views1 answer
Calculer pourcentage mysql
SQL
5 votes166 views4 answers
Sql check
SQL
8 votes207 views2 answers
Oracle undo usage
SQL
10 votes182 views2 answers
Sql pagination offset
SQL
3 votes162 views1 answer
System.debug apex
SQL
0 vote180 views1 answer
Postgres populate table from another table
SQL
0 vote188 views1 answer
Sql missing values
SQL
-1 vote180 views1 answer
Mysql #1064 error
SQL