/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

0 vote298 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote307 views1 answer
Generate random data postgresql
SQL
0 vote292 views1 answer
Sqlalchemy get ids
SQL
0 vote286 views1 answer
Safe mysql
SQL
0 vote326 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote300 views1 answer
Sql examples from framework
SQL
0 vote338 views1 answer
"Hello User Name"
SQL
1 vote301 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote305 views2 answers
Uninstall postgresql mac
SQL
1 vote307 views1 answer
Right outer vs left outer join
SQL