/SQL/How to check nls timestamp format in oracle

How to check nls timestamp format in oracle

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

1 vote194 views1 answer
Mysql select all and rename one
SQL
4 votes157 views2 answers
Postgresql reset sequence
SQL
1 vote178 views1 answer
Mysql find most common value
SQL
6 votes188 views3 answers
What is where in sql
SQL
2 votes173 views3 answers
How to check current user in mySQL
SQL
0 vote209 views2 answers
Find lowest number in sql
SQL
3 votes187 views2 answers
Mysql import gz
SQL
0 vote189 views1 answer
Consecutive numbers sql
SQL
2 votes190 views1 answer
Match in sql server
SQL
0 vote178 views1 answer
Oracle cpu metric
SQL