17,377
社区成员
发帖
与我相关
我的任务
分享
create or replace FUNCTION khggl (v_khmc in varchar2) RETURN number IS
v_khggl number;
BEGIN
select round(sum(gxcd)/1000,3) into v_khggl from (
select distinct c.channelsid,a.gxcd from sip_gxb a ,sip_zkb b ,stru_channels c,stru_hole d,stru_subhole e
where a.gjz=c.channelsid and b.zkbh=e.subholeid and d.holeid=e.holeid and c.windowid=d.windowid
and b.khbh=v_khmc and (b.syzt='合同分配' or b.syzt='预分配') and a.jszt='竣工验收');
return v_khggl;
END;
select khmc,khggl(khmc),khzkgl(khmc),khpjgmzks(khmc)
from mytab