--查看oracle數(shù)據(jù)庫字符集：
    sql代碼
    select userenv('language') from dual;
    查詢結(jié)果：
    simplified chinese_china.al32utf8
    --修改oracle數(shù)據(jù)庫字符集：(在sql plus中)
    sql代碼
    sql> conn / as sysdba;
    sql> shutdown immediate;
    database closed.
    database dismounted.
    oracle instance shut down.
    sql> startup mount;
    oracle instance started.
    total system global area 135337420 bytes
    fixed size 452044 bytes
    variable size 109051904 bytes
    database buffers 25165824 bytes
    redo buffers 667648 bytes
    database mounted.
    sql> alter system enable restricted session;
    system altered.
    sql> alter system set job_queue_processes=0;
    system altered.
    sql> alter system set aq_tm_processes=0;
    system altered.
    sql> alter database open;
    database altered.
    sql> alter database character set internal_use al32utf8;
    sql> shutdown immediate;
    sql> startup;
    修改oracle用戶的nls_lang
    編輯/home/oracle/.bash_profile
    bash代碼
    export nls_lang=simplified chinese_china.al32utf8