declare
begin
for tttt in
(select temp.c_id
from (select cst.c_tci_id, max(ins.T_END_DATE) as endDate
from tb_test_1 t1, tb_test_2 t2
where t1.c_id = t2.c_id
and t1.C_DEL = '0'
group by c_tci_id) temp
where endDate < sysdate)
loop
update tb_test_1 t1
set t1.c_stat ='0'
where t1.c_id = tttt.c_id;
--commit;
end loop;
end;
--
declare
begin
for thecst in
(select temp.c_tci_id
from (select cst.c_tci_id, max(ins.T_END_DATE) as insDate
from tb_test1 cst, tb_test2 ins
where cst.c_tci_id = ins.c_cst_id
and cst.C_DEL = '0'
--and cst.c_stat = '0'
and cst.C_NO_RELEASE = '1'
and ins.C_DEL = '0'
and ins.c_stat is null
and ins.c_is_telesale_ply is null
group by c_tci_id) temp
where insDate < sysdate
and temp.c_tci_id not in
(select cst.c_tci_id
from tb_cst_info cst, tb_ins_info ins
where cst.c_tci_id = ins.c_cst_id
)
)
loop
update tb_test1 cst
set cst.C_NO_RELEASE = '0',cst.T_NO_RELEASE_TIME = sysdate, cst.c_stat ='0'
where cst.c_tci_id = thecst.c_tci_id;
--commit;
end loop;
end;
sql 存储过程 for in loop 使用 业务
最新推荐文章于 2024-11-18 16:33:00 发布