select to_char(sysdate, 'Day'), to_char(sysdate, 'Day', 'NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') from dual;
select to_char(sysdate, 'Day'), to_char(sysdate, 'Day', 'nls_date_language=japanese') from dual;
select to_char(sysdate, 'Day'), to_char(sysdate, 'Day', 'nls_date_language=english') from dual;
查看客户端的字符集
1. select * from nls_session_parameters;
可以通过这两个参数来设置
nls_language 和 nls_territory
总控字符集参数
nls_Lang= French_France.UTF8 (格式三部分)