NLS_LANG SIMPLIFIED CHINESE_CHINA.AL32UTF8 和american_america.AL32UTF8

最新推荐文章于 2024-01-10 14:58:23 发布

weixin_30404405

最新推荐文章于 2024-01-10 14:58:23 发布

阅读量1.9k

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/6200424.html

版权

oadb01:/home/oracle> echo $NLS_LANG
SIMPLIFIED CHINESE_CHINA.AL32UTF8
oadb01:/home/oracle> sqlplus query/query

SQL*Plus: Release 11.2.0.4.0 Production on 星期一 2月 15 20:49:30 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> COL NICK FORMAT A30  
SQL> SELECT * FROM DENGJI;

NICK			       F CREATETIME
------------------------------ - --------------
赵杨健                         1 15-2月 -16


oadb01:/home/oracle> export NLS_LANG=american_america.AL32UTF8
oadb01:/home/oracle> sqlplus query/query

SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 15 20:51:25 2016

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> COL NICK FORMAT A30
SQL> SELECT * FROM DENGJI;

NICK			       F CREATETIME
------------------------------ - ------------------
赵杨健                         1 15-FEB-16

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6200424.html