cmd下 修改语言环境

修改语言环境为英文,如下:
改为英文: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 =
将语言改为英语: 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;

你可能感兴趣的