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 vote126 views1 answer
How to use a trigger to validate input data
SQL
7 votes220 views1 answer
Oracle alter sequence restart start with
SQL
0 vote240 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote159 views1 answer
Except in sql
SQL
17 votes166 views6 answers
Get last record in sql
SQL
0 vote157 views1 answer
Trigger stock phpmyadmin
SQL
79 votes323 views6 answers
Grepper code
SQL
0 vote136 views1 answer
Top 3 salary in sql
SQL
0 vote173 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote130 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL