/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

11 votes285 views3 answers
Pl sql example
SQL
7 votes315 views2 answers
Sql remove duplicates based on column
SQL
1 vote289 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote259 views1 answer
Power bi dax add related shows column but not working
SQL
1 vote276 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
6 votes296 views2 answers
Postgresql database url
SQL
0 vote264 views1 answer
Get time component of datetime sql
SQL
3 votes288 views2 answers
Search text in all sql server stored procedure
SQL
0 vote291 views1 answer
How to update date value in sql
SQL
9 votes268 views6 answers
Sql add column with default value
SQL