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 vote218 views1 answer
Sql delete all values in a column
SQL
0 vote232 views1 answer
Sql last 3 rows
SQL
0 vote221 views1 answer
Split string by comma in sql server
SQL
1 vote223 views1 answer
Add sequence postgres
SQL
1 vote246 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote248 views1 answer
Mysql dump with table query
SQL
1 vote176 views1 answer
Ms sql - add one hour to time
SQL
0 vote276 views1 answer
Sql query to select even numbers
SQL
0 vote225 views1 answer
Commit transaction sql
SQL
0 vote224 views1 answer
Mysql Error Code: 1005
SQL