Question

如何将数据库查询值返回给shell变量

Answer 1

#!/bin/bash
l_last_date=`date +%Y%m%d --date="1 day ago"`
sqlplus /nolog<<ENDOFINPUT
whenever sqlerror exit 20;
whenever oserror exit 20;
connect hxl/hxl;
variable cnt number;
begin
select Count(1) into :cnt from tb_kettle_finish_info t where t.statedate=${l_last_date}
if :cnt >0 then
exit 30;
else
exit 40;
end if;
end;
/
ENDOFINPUT
echo $?