Oracle get nls settings

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 votes187 views2 answers
Sql join
SQL
0 vote185 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote205 views1 answer
Error code 1292 mysql workbench
SQL
0 vote187 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote192 views1 answer
Comma seperated join mssql
SQL
0 vote214 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote198 views1 answer
What is default mysql database password in linux
SQL
0 vote200 views1 answer
Sql reverse order of results
SQL
0 vote227 views2 answers
Start mysql server using docker
SQL
15 votes209 views6 answers
Laravel db transaction
SQL