alter session set nls_language nls_date_language
alter session, nls_language, nls_date_language, AMERICAN, SIMPLIFIED CHINESE[@more@]-- set languagealter session set nls_language ='AMERICAN';alter session set nls_language = 'SIMPLIFIED CHINESE';-- set date languagealter session set nls_date_language='AMERICAN';alter session set nls_date_language='SIMPLIFIED CHINESE';-- view session nls_languageselect USERENV('LANG') from DUAL;-- view session nls_date_languageselect SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE') nls_date_language from DUAL;