SQL 针对于 ORACLE
执行语句如下 :
create or replace procedure zxsc(mn in varchar2) is
cursor cur is (
SELECT tbd_datatime datatime ,
to_char((to_date(tbd_datatime,‘yyyy/mm/dd hh24:mi:ss’)-
to_date(lead(tbd_datatime) over(order by tbd_datatime desc),‘yyyy/mm/dd hh24:mi:ss’))2460) mis
FROM t_basic_data_head
WHERE tbd_mn = mn);
begin
for item in cur loop
if item.mis > 10 then
delete from T_DATA_PUBLIC where dataTYPE=‘lxzxsc’ and datamn = mn ;
insert into T_DATA_PUBLIC (DATA, dataTYPE,datamn) values (floor((sysdate-to_date(item.datatime,‘yyyy/mm/dd hh24:mi:ss’))*24),‘lxzxsc’,mn);
exit;
end if;
end loop;
end;