Oracle nls instance

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

-3 votes176 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote181 views2 answers
How to delete the rows with null values in mysql
SQL
2 votes179 views1 answer
Sql find not in list
SQL
1 vote169 views1 answer
Mysql sort by date column
SQL
0 vote158 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
1 vote197 views1 answer
Show databases mysql docker
SQL
19 votes172 views6 answers
Mysql if null
SQL
2 votes212 views1 answer
Oracle find constraints referencing a table
SQL
1 vote176 views2 answers
How to search date in sql query
SQL
10 votes182 views4 answers
How to alter table name in mysql
SQL