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

0 vote192 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote232 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
5 votes180 views1 answer
Minecraft java port number
SQL
0 vote190 views1 answer
Oracle table free space
SQL
1 vote188 views2 answers
Laravel get sql query eloquent with parameters
SQL
3 votes182 views1 answer
Oracle wait
SQL
0 vote211 views1 answer
Allow null in psql
SQL
0 vote196 views1 answer
Postgres list all triggers
SQL
0 vote179 views1 answer
Show database not empty tables postgres
SQL
0 vote245 views1 answer
Generate random & unique mysql string
SQL