#该函数带commit,需注意
executeSql()
{
if [ $# = 2 ]
then
_ORACLEID=$1
_SQL=$2
else
_ORACLEID="$conn"
_SQL=$1
fi
_result=`echo "set echo off\nset feedback off\nset heading off\nset newpage 0\nset pagesize 0\n$_SQL;\ncommit;\nexit;\n"|sqlplus -s $_ORACLEID`
echo "$_result"
}
conn=inter/inter123@billdb
#用法:
YYYYMMDD=`executeSql "$conn" "select to_char(sysdate,'YYYYMMDD') from dual"`
echo "YYYYMMDD=$YYYYMMDD"
#这样YYYYMMDD就得到结果了