环境变量NLS_LANG 语言_地区.字符集的获取

查询库字符集，生成export语句

select 'export NLS_LANG=' || l.VALUE || '_' || t.VALUE || '.' || c.VALUE as "setNLS_LANG"
  from NLS_DATABASE_PARAMETERS l,
       NLS_DATABASE_PARAMETERS t,
       NLS_DATABASE_PARAMETERS c
 where l.PARAMETER = 'NLS_LANGUAGE'
   and t.PARAMETER = 'NLS_TERRITORY'
   and c.PARAMETER = 'NLS_CHARACTERSET';
-- 生成诸如：export NLS_LANG=AMERICAN_AMERICA.UTF8
-- Linux环境变量设置语句