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

1 vote346 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote325 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
-1 vote343 views1 answer
Get id from just inserted row mysql server python
SQL
5 votes366 views4 answers
Upload database mysql command line
SQL
0 vote358 views1 answer
Set engine to innodb
SQL
4 votes320 views1 answer
Mysql insert from local csv
SQL
0 vote382 views1 answer
Sql find gaps in date ranges
SQL
0 vote361 views1 answer
Providername system.data. mysql
SQL
1 vote330 views2 answers
Sql select only first occurrence
SQL
0 vote337 views1 answer
Oracle db get table sizes
SQL