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

13 votes321 views3 answers
List all the tables in sql
SQL
0 vote299 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote294 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote319 views2 answers
Amazon linux postgresql client
SQL
0 vote270 views1 answer
Sql compound operators
SQL
0 vote302 views2 answers
Drop tables from local table database postgres
SQL
7 votes285 views1 answer
Alter sequence set current value oracle
SQL
0 vote317 views1 answer
Write SQL in ruby on rails
SQL
0 vote281 views1 answer
Mysql date only no time
SQL
1 vote362 views1 answer
Postgresql can you have null foreign key
SQL