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

sohusina

1. value=`sqlplus /nolog<<ENDOFINPUT
   
2.     whenever sqlerror exit 20;
   
3.     whenever oserror exit 20;
   
4.     connect hxl/hxl;
   
5.     variable cnt number;
   
6.     begin
   
7.     select Count(1) into :cnt from tb_kettle_finish_info t where t.statedate=${l_last_date}
   
8.     if :cnt >0 then
   
9.      exit 30;
   
10.     else
    
11.      exit 40;
    
12.     end if;
    
13.     end;
    
14. /
    
15. exit
    
16. ENDOFINPUT`
    
17. 
    
18. echo $value

复制代码