sql改变语言环境

Declare

  v_sql varchar2(100);

begin

  v_sql := 'alter session set nls_language =' || '''american''';

  execute immediate v_sql;

exception

  when others then

    fnd_file.PUT_LINE(fnd_file.OUTPUT, '语言改变失败!');

end;

 

 

ALTER

SESSION

SET

NLS_LANGUAGE=american;

 

--ALTER

SESSION

SET

NLS_LANGUAGE='SIMPLIFIED

CHINESE'