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

0 vote292 views1 answer
Denormalise SQL command
SQL
1 vote312 views1 answer
Mysql not supported auth mode
SQL
0 vote300 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote285 views1 answer
Backup a table in sql
SQL
3 votes350 views5 answers
No module named 'MySQLdb'
SQL
0 vote317 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
24 votes348 views6 answers
Sql change table name
SQL
0 vote349 views1 answer
Mysql relationships between tables
SQL
5 votes340 views1 answer
Get column name sql server
SQL
37 votes483 views3 answers
Sql check duplicate value in column
SQL