/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 vote258 views1 answer
How to check the mysql version mac
SQL
1 vote279 views3 answers
How to filter repeated same result using sql query
SQL
0 vote258 views1 answer
Porcentaje sql
SQL
1 vote245 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote267 views1 answer
Mysql date format unix timestamp
SQL
0 vote271 views3 answers
Classement rang mysql 7
SQL
0 vote305 views1 answer
Get total and distict row diff in sql
SQL
20 votes293 views1 answer
Get all table name in sql through php
SQL
3 votes301 views5 answers
No module named 'MySQLdb'
SQL
0 vote267 views1 answer
Mysql update table from select on another table
SQL