Oracle nls parameters

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 votes121 views5 answers
Oracle list tables
SQL
0 vote179 views1 answer
Ora 00001 error catch plsql
SQL
2 votes78 views1 answer
Sql view column data type
SQL
0 vote131 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote138 views1 answer
Can you write relational algebra into sql queries
SQL
3 votes137 views6 answers
DB::table('users')->get();
SQL
0 vote129 views1 answer
Delete data from database sqlite android
SQL
28 votes125 views4 answers
Mysql delete database
SQL
0 vote124 views1 answer
Sql case sttement with set
SQL
15 votes130 views6 answers
Psql
SQL