/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

3 votes335 views1 answer
V$session not found in oracle
SQL
0 vote371 views1 answer
Sqlalchemy query sql compiled
SQL
20 votes372 views3 answers
How to open postgresql in mac
SQL
0 vote338 views1 answer
Mysql delete from where like
SQL
10 votes387 views4 answers
Else if mysql
SQL
1 vote374 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
-2 votes347 views1 answer
Mysql not empty
SQL
4 votes346 views3 answers
Mysql varchar length
SQL
0 vote359 views1 answer
Tsql generate rows
SQL
0 vote353 views1 answer
PSQL qith variables
SQL