set enviroment in python or bash
- os.environ["NLS_LANG"] = "TRADITIONAL CHINESE_HONG KONG.AL32UTF8"
or - export NLS_LANG="TRADITIONAL CHINESE_HONG KONG.AL32UTF8"
get lang in Oracle
- SELECT USERENV ('language') FROM DUAL;
- select * from v$nls_parameters WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');
- SELECT * from NLS_DATABASE_PARAMETERS WHERE parameter IN ( 'NLS_LANGUAGE', 'NLS_TERRITORY', 'NLS_CHARACTERSET');
others
- select * FROM V$NLS_VALID_VALUES;
- select * from NLS_SESSION_PARAMETERS;
- select * from database_properties;
转载于:https://my.oschina.net/l1z2g9/blog/175955