oracle选择语言设置,oracle本地语言变量设置

select userenv('language') from dual

察看当前会话的语言环境变量设置：

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')

----------------------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

修改当前会话的语言环境变量设置：

SQL> ALTER SESSION SET =

察看语言设置信息：

SET PAGESIZE 100

SQL> col PARAMETER format a30

SQL> col VALUE format a30

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_DAT