修改语言环境为英文,如下:
改为英文:C:/Documents and Settings/zhenhuan_yu>set nls_lang=american_america.zhs16gbk
改为中文:C:\Documents and Settings\Administrator>set nls_lang=SIMPLIFIED CHINESE_CHINA.ZH
S16GBK
C:/Documents and Settings/zhenhuan_yu>rman target /
在sql下修改如下:
SQL> 修改当前会话的语言环境变量参数:
ALTER SESSION SET <nls_parameter> = <value>
将语言改为英语: SQL> ALTER SESSION SET NLS_LANGUAGE=american;
Session altered. 将语言改回中文:
SQL> ALTER SESSION SET NLS_LANGUAGE=’SIMPLIFIED CHINESE’;
会话已更改。将地域改为英文:
SQL> ALTER SESSION SET NLS_TERRITORY=america;
会话已更改。将地域改为中文:
SQL> ALTER SESSION SET NLS_TERRITORY=CHINA; 会话已更改
查看当前语言环境:
select userenv(‘language’) from dual;
cmd下 修改语言环境
最新推荐文章于 2023-08-19 21:11:22 发布