博客

— 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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28345171/viewspace-2144337/，如需转载，请注明出处，否则将追究法律责任。