摘自:http://blog.itpub.net/28345171/viewspace-2144337/
alter session set nls_language nls_date_language
原创 Oracle 作者:joeyoungebs 时间:2017-08-30 17:22:34 1115 0
Alter session set nls_language, nls_date_language to AMERICAN, SIMPLIFIED CHINESE
-- set language
alter session set nls_language ='AMERICAN';
alter session set nls_language = 'SIMPLIFIED CHINESE';
-- set date language
alter session set nls_date_language='AMERICAN';
alter session set nls_date_language='SIMPLIFIED CHINESE';
-- view session nls_language
select USERENV('LANG') from DUAL;
-- view session nls_date_language
select SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE') nls_date_language from DUAL;