怎么把一个值加一啊？？？？

chen_chen1212

batch=`$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWORD}@${SID} <<EOF
set heading off
set feedback off
set serverout on
select max(BATCH_ID) from BIZ_ACC_TRANSFER_DATA;
exit
EOF`
batch=batch+1;这个不对？？
echo $batch

chen_chen1212

回复 2# 99超人


    batch=`$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWORD}@${SID} <<EOF
set heading off
set feedback off
set serverout on
select max(BATCH_ID) from BIZ_ACC_TRANSFER_DATA;
exit
EOF`
((batch=batch+1))
echo $batch
还是不对啊

iori809

echo $((batch=batch+1))

chen_chen1212

回复 4# iori809


    batch=`$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWORD}@${SID} <<EOF
set heading off
set feedback off
set serverout on
select max(BATCH_ID) from BIZ_ACC_TRANSFER_DATA;
exit
EOF`
echo $((batch=batch+1))
不对啊

chen_chen1212

回复 6# 99超人


    数据库里面是个char型的，怎么转换啊

Shell_HAT

回复 5# chen_chen1212

batch=`$ORACLE_HOME/bin/sqlplus ${USER}/${PASSWORD}@${SID} <<EOF
set heading off
set feedback off
set serverout on
select max(BATCH_ID) from BIZ_ACC_TRANSFER_DATA;
exit
EOF`
echo China${batch}Unix

把执行的结果贴出来看看