alter session nls_language nls_date_language

alter session, nls_language, nls_date_language, 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;