/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

50 votes432 views6 answers
Sql duplicate rows
SQL
10 votes355 views5 answers
Between keyword in sql
SQL
20 votes338 views2 answers
Counting in sql
SQL
17 votes363 views2 answers
Mysql date to string
SQL
28 votes365 views6 answers
Mysql change user password
SQL
0 vote337 views1 answer
Soql more than today
SQL
0 vote341 views1 answer
Composit key in sql
SQL
5 votes383 views4 answers
Upload database mysql command line
SQL
0 vote410 views1 answer
Mysql backup query
SQL
-1 vote334 views2 answers
Full join sql
SQL