Shulou(Shulou.com)06/01 Report--

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 (39) | | Pi_Nls_Lang | | Chr (39); EXCEPTION WHEN OTHERS THEN EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_LANGUAGE=' | | Chr (39) | |' SIMPLIFIED CHINESE' | | Chr (39) END p_Set_Nls_Language

Commonly used 'SIMPLIFIED CHINESE'' and 'AMERICAN''

Query NLS parameters at all levels:

SELECT * FROM nls_database_parameters;SELECT * FROM nls_instance_parameters;SELECT * FROM nls_session_parameters

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.