修改nls_date_format的步骤

最新推荐文章于 2019-07-09 21:01:58 发布

cuanjia1708

最新推荐文章于 2019-07-09 21:01:58 发布

阅读量115

点赞数

SQL> show parameter nls_date_format

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
nls_date_format string

SQL> alter system set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' scope =spfile
2 ;

System altered.

SQL> show parameter nls_date_format

NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
nls_date_format string

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 3204448256 bytes
Fixed Size 2024272 bytes
Variable Size 637537456 bytes
Database Buffers 2550136832 bytes
Redo Buffers 14749696 bytes
Database mounted.
Database opened.
SQL> show parameter nls_date_format

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string YYYY-MM-DD HH24:MI:SS

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7724693/viewspace-981213/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7724693/viewspace-981213/