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

0 vote201 views1 answer
Sum value by month sql
SQL
0 vote213 views2 answers
How to get last inserted id in sql server c#
SQL
4 votes289 views4 answers
Update select mysql
SQL
8 votes266 views2 answers
Python simple connect to mysql
SQL
5 votes218 views3 answers
String concatenation sql server
SQL
0 vote209 views1 answer
Mysql join column order By and group By
SQL
0 vote187 views1 answer
Check if table exists oracle
SQL
36 votes317 views6 answers
Change column data type sql
SQL
0 vote205 views1 answer
Postgresql copy backup table
SQL
0 vote239 views2 answers
What is 1=2 in sql
SQL