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

2 votes138 views2 answers
Sqlalchemy filter or
SQL
0 vote146 views4 answers
Change schema in sql server
SQL
0 vote156 views1 answer
Hashpass
SQL
5 votes154 views1 answer
Purge undo tablespace usage
SQL
0 vote164 views1 answer
Convert LDAP Epoch to Date
SQL
6 votes184 views2 answers
Install psql mac
SQL
0 vote149 views1 answer
Add two days to current date in sql when creating tables
SQL
11 votes259 views2 answers
Import mysql dump command line windows
SQL
0 vote136 views1 answer
Concatenate columns in table
SQL
4 votes128 views2 answers
Linq join
SQL