我遇到了这个问题吗?
我有一个使用占位符持有SQL的变量:
echo $SQL
SELECT PX_PROMOTION_ID, PRIORITY, STATUS, EXCLSVE, TYPE, PERORDLMT, PERSHOPPERLMT, TOTALLMT, RSV_INT, PX_GROUP_ID, CAMPAIGN_ID, STOREENT_ID, VERSION, REVISION, EFFECTIVE, TRANSFER, CDREQUIRED, EXPIRE, LASTUPDATEBY, TO_CHAR(LASTUPDATE, 'YYYYMMDD HH24MMSS') AS LASTUPDATE, TO_CHAR(STARTDATE, 'YYYYMMDD HH24MMSS') AS STARTDATE, TO_CHAR(ENDDATE, 'YYYYMMDD HH24MMSS') AS ENDDATE, TO_CHAR(RSV_TIME, 'YYYYMMDD HH24MMSS') AS RSV_TIME, RSV_REAL, TGTSALES, NAME, CODE, RSV_VCH, OPTCOUNTER FROM PX_PROMOTION WHERE LASTUPDATE BETWEEN (SELECT MAX(BATCHSTART) FROM XRPTEBATCHCONTROL) AND TIMESTAMP('$BATCH_END')
我有另一个变量保存值:
echo $BATCH_END
2012-11-14 17:06:13
我想用占位符替换值。我对Unix脚本不是特别好,但是我已经尝试过:
echo $SQL | sed -e "s/'$BATCH_END/$BATCH_END/g"
但它仍然没有被替换…
谁能帮忙?我想替换占位符,并将最终的字符串保留到$ SQL
我还需要知道如何将输出的值重新输入到变量中,例如,我试过:
SQL=`echo "$SQL" | echo "${SQL//\$BATCH_END/$BATCH_END}"`