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

12 votes269 views6 answers
Between in sql
SQL
1 vote274 views2 answers
Test sqlsrv connection
SQL
5 votes276 views1 answer
Get table columns from sql
SQL
0 vote288 views1 answer
Carbon mysql d m y to y-m-d
SQL
12 votes250 views1 answer
Create column sql server
SQL
0 vote267 views1 answer
Python mysql query to dataframe
SQL
2 votes294 views2 answers
Create temporary table in mysql
SQL
7 votes270 views6 answers
Reset identity column in sql server
SQL
0 vote264 views1 answer
Mysql search multiple tables
SQL
11 votes270 views2 answers
Turn off safe mode mysql
SQL