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

8 votes179 views1 answer
Oracle search stored procedures for text
SQL
5 votes181 views1 answer
Oracle drop index if exists
SQL
13 votes162 views2 answers
Display users in mysql
SQL
0 vote195 views1 answer
"Hello User Name"
SQL
1 vote178 views2 answers
Logical operators in sql
SQL
3 votes216 views2 answers
Update part of a string in mysql
SQL
0 vote133 views1 answer
Raven ql select count
SQL
0 vote170 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote163 views1 answer
Can't connect to postgresql mac os
SQL
0 vote178 views1 answer
Tsql pad left
SQL