修改oracle的profile文件:

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
unset USERNAME
export ORACLE_HOME=$HOME/oracle/product/10.2.0/db_1
export ORACLE_SID=orca
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib:$ORACLE_HOME/precomp/public
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"     ---加上SQL查询可以显示中文，若没有显示则为？？？ 
stty -istrip -parmrk cs8
stty erase "^H"kill"^U"intr"^C"eof"^D"                   ---在SQL下可以任意使用退格键