if to_number(to_char(sysdate,'hh24'))-7>0 then FromDate :=to_char(sysdate,'yyyymmdd')||'070000'; elsif(to_number(to_char(sysdate,'hh24'))-7<0 then FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000'; else if(to_number(to_char(sysdate,'hh24'))-7=0 then return;//执行XXXX end if ;
if to_number(to_char(sysdate,'hh24'))-7>0 then FromDate :=to_char(sysdate,'yyyymmdd')||'070000'; elsif(to_number(to_char(sysdate,'hh24'))-7<0 then FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000'; elsif(to_number(to_char(sysdate,'hh24'))-7=0 then return;//执行XXXX end if ;
if to_char(sysdate,'hh24')-7>0 then FromDate :=to_char(sysdate,'yyyymmdd')||'070000'; else if(to_char(sysdate,'hh24')-7<0 then FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000'; else if(to_char(sysdate,'hh24')-7=0 then return; end if ; --执行存储过程放在end if后面 //执行XXXX
不是buselse if 是 elsif
if to_char(sysdate,'hh24')-7>0 then FromDate :=to_char(sysdate,'yyyymmdd')||'070000'; elsif (to_char(sysdate,'hh24')-7<0 then FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000'; elsif (to_char(sysdate,'hh24')-7=0 then //执行XXXX end if ;
dat number:=to_number(to_char(sysdate,'hh24')); --定义全局变量if dat-7>0 then FromDate :=to_char(sysdate,'yyyymmdd')||'070000'; elsif dat-7<0 then FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000'; else return; end if ; //执行XXXX --这段一定要放在if... end if后执行
FromDate :=to_char(sysdate,'yyyymmdd')||'070000';
elsif(to_number(to_char(sysdate,'hh24'))-7<0 then
FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000';
else if(to_number(to_char(sysdate,'hh24'))-7=0 then
return;//执行XXXX
end if ;
FromDate :=to_char(sysdate,'yyyymmdd')||'070000';
elsif(to_number(to_char(sysdate,'hh24'))-7<0 then
FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000';
elsif(to_number(to_char(sysdate,'hh24'))-7=0 then
return;//执行XXXX
end if ;
FromDate :=to_char(sysdate,'yyyymmdd')||'070000';
else if(to_char(sysdate,'hh24')-7<0 then
FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000';
else if(to_char(sysdate,'hh24')-7=0 then
return;
end if ;
--执行存储过程放在end if后面
//执行XXXX
是
elsif
if to_char(sysdate,'hh24')-7>0 then
FromDate :=to_char(sysdate,'yyyymmdd')||'070000';
elsif (to_char(sysdate,'hh24')-7<0 then
FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000';
elsif (to_char(sysdate,'hh24')-7=0 then
//执行XXXX
end if ;
FromDate :=to_char(sysdate,'yyyymmdd')||'070000';
elsif dat-7<0 then
FromDate :=to_char(sysdate-1,'yyyymmdd')||'070000';
else
return;
end if ;
//执行XXXX --这段一定要放在if... end if后执行