Question

shell脚本怎么获取sql select count(*)语句的结果

类似这条语句
db2 "select count(*) from JD_IMBS_T_SIGN_HIST where EXPORT_DATE='2016-02-24'"

Answer 1

单引号换成双引号：
echo “select count(*) from ${tablename};” | sqlplus $ACCOUNT/$PASSWORD@$ORACLE_LOGIP:1521/$SID > ${TMPFILE}