简单统计报表例子（存储过程）

 1 create or replace procedure bb_quxzbmjdqzxfqk_ces(kssj in date, 2                                          jssj  3                                          wtsd2 varchar2,128)"> 4                                          tjjg out sys_refcursor) as
 5 
 6 begin
 7    delete from A_TJBB_quxzbmjdqzxfqk;
 8 commit;
 9 insert into A_TJBB_quxzbmjdqzxfqk
10 select jj.iidd,jj.isedit,jj.djjgbh,jj.cfxfjbz,jj.lmbz,jj.xfrs,jj.xfxs from visit_xfj jj,128)">11  hr_organization n where n.jglb='1200' and  n.region_dm=wtsd2 and n.bh=jj.djjgbh and jj.djsj between kssj and jssj;
12 13   open tjjg for
14 
15 
16 select l.mc as mc,128)">17  count(1) as jianci,128)">18 sum(case when xf.xfxs100' then 1 else
19  200then xf.xfrs 20  when xf.xfxs in (300',303') 1
21  else 0 end end) as rci,128)">22 and xf.lmbz0'and xf.cfxfjbzend)as grlx,128)">23 1as lmx,128)">24 as cfgrlx,128)">25 as cflmx,128)">26 as xiaojie,128)">27 and xf.xfrs<=4 as c1lfcjjc,128)">28 as c1lfcjrc,128)">29 and( xf.xfrs>=5 49) as c5lfcjjc,128)">30 as c5lfcjrc,128)">31 50 499) as c50lfcjjc,128)">32 then  xf.xfrs as c50lfcjrc,128)">33 500 as c500lfcjjc,128)">34 as c500lfcjrc,128)">35 as cf1lfcjjc,128)">36 as cf1lfcjrc,128)">37 as cf5lfcjjc,128)">38 as cf5lfcjrc,128)">39 as cf50lfcjjc,128)">40 as cf50lfcjrc,128)">41 as cf500lfcjjc,128)">42 as cf500lfcjrc,128)">43 as lxxiaojjc,128)">44 as lxxiaojrc,128)">45 in(') as grts,128)">46 as lmts,128)">47 
48 as cfgrts,128)">49 
50 as cflmts,128)">51 as xiaoji
52 
53   from hr_organization l,A_TJBB_quxzbmjdqzxfqk xf where  l.jglband  l.region_dm500101and l.bh=xf.djjgbh group by l.mc;
54 
55   end bb_quxzbmjdqzxfqk_ces;

————————————————————————————————————————————————————————————————————

 4                                          isquxian  5                                          tjjg out GLOBALPKG.RCT1)  6 
 7  8    v_kssj1 :=kssj;
 9    v_jssj1 :=jssj;
10   11 
12 
13 14  15 16  18  19 20 21 44 
46 
47 50   where  l.region_dmand   ((v_kssj1 is not null and j.adddatetime between v_kssj1 and v_jssj1) 
51 or (v_kssj1 not nulll and 1=1))  and((isquxian and ion.dm = isquxian ) or (isquxian is 1 = 1)) and l.jglband 
53 l.bhend bb_quxzbmjdqzxfqk_ces;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!