脚本中定义,格式:define 标识符 = 值
sqlplus -S $USER/$PASSWD <<EOF
define a=$a
define b=$b
@insert_sql/${TBLID}.sql a b
exit
quit
EOF
SELECT
'&a'
FROM
R
WHERE
C= '&b'
注意sql文件里面,要在变量两边加个单引号,不然会提示变量没有定义的错误。
count=`${TBLID,,}_diff $KAISHACD $KAISHACDOLD $KAISHACDOLD $KAISHACD`
function diff(){
cnt=`sqlplus -s $USER/$PASSWD << EOF
SET FEEDBACK OFF
SET HEADING OFF
select
NVL(COUNT(*) , 0)
from
RBJF031C
where
KA = '$1'
KAI = '$2'
exit
quit
EOF
`
echo $cnt
}
参数必须用&[1-9]表示,不然传不进去,会提示让手动输入参数