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 vote320 views1 answer
Oracle procedure teamplate
SQL
11 votes349 views5 answers
Update table from another table mysql
SQL
0 vote351 views1 answer
What is database username and password in mysqliconnect
SQL
4 votes313 views1 answer
Create column mysql terminal
SQL
0 vote293 views1 answer
Count column of tables psql
SQL
6 votes329 views1 answer
T-sql test if table exists
SQL
2 votes373 views2 answers
Null column to 0 in mysql
SQL
0 vote340 views1 answer
Mysql set variable to today's date
SQL
0 vote343 views1 answer
How to find total working hour in sql
SQL
3 votes395 views2 answers
Oracle drop sequence
SQL