Oracle Session Nls_language

The following code can be added to the package to modify the language parameters of the current session.

--Set Session language     procedure p_set_nls_language (pi_nls_lang in varchar2  default  ' Simplified chinese ')  IS    BEGIN         EXECUTE IMMEDIATE  ' alter session set nls_language= '  | |  CHR ( |) |                            pi_nls_lang | |  CHR (;    exception        when ) Others then            execute immediate   ' alter session set nls_language= '  | |  CHR ( |) |                                 ' SimplifIed chinese '  | |  CHR (;    end p_set_nls_language;)

Generally used ' Simplified Chinese ' and ' AMERICAN '

Query the NLS parameters at all levels:

SELECT * from Nls_database_parameters; SELECT * from Nls_instance_parameters; SELECT * from Nls_session_parameters;

This article is from the "Long Way to repair ..." Blog, be sure to keep this source http://baser.blog.51cto.com/4153192/1546061

Oracle Session Nls_language