用SHELL脚本把字符编码转换插到oralce

#!/bin/bash

source /home/gbase/.bash_profile

export  LANG=GB2312

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

iconv -f utf-8 GB2312 $file >$newfile

content="$(cat $newfile)"

sqlplu scott/tiger@servicename >> $log <<EOF

sql_stmt

EOF;