Oracle v $ 参数和数据库属性之间的nls_date_format差异

SQL> select value from v$parameter where name = 'nls_date_format';

VALUE
--------------------------------------------------------------------------------
DD-MON-RR

SQL> alter session set nls_date_format = 'yyyy-mm-dd';

Session altered.

SQL> select value from v$parameter where name = 'nls_date_format';

VALUE
--------------------------------------------------------------------------------
yyyy-mm-dd

1 row selected.
复制