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;会话已更改。
数据库ORACLE修改当前会话的语言环境参数 数据库ORACLE修改当前会话的语言环境参数对于数据库ORACLE有时操作时,提示的是一串串???,不能起到提示的作用,这是由于语言环境的设置问题,下面是实际操作中要用到的。查看当前会话的语言环境: SQL> select userenv('language') from dual;USERENV('LANGUAGE') ---------------------------------------------------- SIMPLIFIED CHINESE_CHINA.ZHS16GBK查看语言设置情况: SQL> SET PAGESIZE 80 SQL> col PARAMETER format a35 SQL> col VALUE format a35 SQL> select * from v$NLS_PARAMETERS;PARAMETER VALUE ----------------------------------- ----------------------------------- NLS_LANGUAGE SIMPLIFIED CHINESE NLS_TERRITORY CHINA NLS_CURRENCY RMB NLS_ISO_CURRENCY CHINA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE SIMPLIFIED CHINESE NLS_CHARACTERSET ZHS16GBK NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY RMB NLS_NCHAR_CHARACTERSET US7ASCII NLS_COMP BINARY已选择17行。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;会话已更改
SQL> select userenv('language') from dual;USERENV('LANGUAGE') ---------------------------------------------------- SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> set pagesize 80 SQL> col parameter format a35; SQL> col value format a35;SQL> select * from V$NLS_PARAMETERS;PARAMETER VALUE ----------------------------------- ----------------------------------- NLS_LANGUAGE SIMPLIFIED CHINESE NLS_TERRITORY CHINA NLS_CURRENCY ¥ NLS_ISO_CURRENCY CHINA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE SIMPLIFIED CHINESE NLS_CHARACTERSET ZHS16GBK NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY ¥ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE19 rows selected.
Session altered.将语言改回中文:
SQL> ALTER SESSION SET NLS_LANGUAGE='SIMPLIFIED CHINESE';
会话已更改。将地域改为英文:
SQL> ALTER SESSION SET NLS_TERRITORY=america;
会话已更改。将地域改为中文:
SQL> ALTER SESSION SET NLS_TERRITORY=CHINA;会话已更改。
数据库ORACLE修改当前会话的语言环境参数对于数据库ORACLE有时操作时,提示的是一串串???,不能起到提示的作用,这是由于语言环境的设置问题,下面是实际操作中要用到的。查看当前会话的语言环境:
SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK查看语言设置情况:
SQL> SET PAGESIZE 80
SQL> col PARAMETER format a35
SQL> col VALUE format a35
SQL> select * from v$NLS_PARAMETERS;PARAMETER VALUE
----------------------------------- -----------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY RMB
NLS_NCHAR_CHARACTERSET US7ASCII
NLS_COMP BINARY已选择17行。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;会话已更改
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> set pagesize 80
SQL> col parameter format a35;
SQL> col value format a35;SQL> select * from V$NLS_PARAMETERS;PARAMETER VALUE
----------------------------------- -----------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY ¥
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ¥
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE19 rows selected.
set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
然后再sqlplus sys/manager as sysdba登陆进去看看是不是变成中文了