oracle编码修改

编码

shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
alter database open;
alter database character set internal_use [编码];
shutdown immediate;
startup;

参考： 编码字符集

语言环境

ALTER SESSION SET <nls_parameter> = <value> 
# 将语言改为英语
ALTER SESSION SET NLS_LANGUAGE=american;
# 将地域改为英文
ALTER SESSION SET NLS_TERRITORY=america; 

查看当前编码语言

select userenv('language') from dual;