declare 请问下提示第3行第7列select没有into
declare startDate varchar2(8):= '20070508 ';
endDate varchar2(8):= '20070808 ';
begin select * from
(select a.rcv_ins_id_cd,nvl(txncntA,0)txncntA,nvl(txncntB,0)txncntB,nvl(txncntC,0)txncntC,nvl(txncntD,0)txncntD,nvl(txncntE,0)txncntE,nvl(txncntF,0)txncntF,nvl(txncntG,0)txncntG,nvl(txncntH,0)txncntH,nvl(txncntI,0)txncntI,nvl(txncntJ,0)txncntJ from
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntA from tsfana where trans_id = 'S25 ' and dom_ext_in = '1 ' and trans_at <=5000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)a
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntB from tsfana where trans_id = 'S33 ' and dom_ext_in = '1 ' and trans_at <=5000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)b
on a.rcv_ins_id_cd = b.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntC from tsfana where trans_id = 'S25 ' and dom_ext_in = '1 ' and trans_at > 5000 and trans_at <= 10000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)c
on a.rcv_ins_id_cd = c.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntD from tsfana where trans_id = 'S33 ' and dom_ext_in = '1 ' and trans_at > 5000 and trans_at <= 10000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)d
on a.rcv_ins_id_cd = d.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntE from tsfana where trans_id = 'S25 ' and dom_ext_in = '1 ' and trans_at > 10000 and trans_at <= 50000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)e
on a.rcv_ins_id_cd = e.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntF from tsfana where trans_id = 'S33 ' and dom_ext_in = '1 ' and trans_at > 10000 and trans_at <= 50000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)f
on a.rcv_ins_id_cd = f.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntG from tsfana where trans_id = 'S25 ' and dom_ext_in = '1 ' and trans_at > 50000 and trans_at <= 100000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)g
on a.rcv_ins_id_cd = g.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntH from tsfana where trans_id = 'S33 ' and dom_ext_in = '1 ' and trans_at > 50000 and trans_at <= 100000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)h
on a.rcv_ins_id_cd = h.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntI from tsfana where trans_id = 'S25 ' and dom_ext_in = '1 ' and trans_at > 100000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)i
on a.rcv_ins_id_cd = i.rcv_ins_id_cd
left outer join
(select rcv_ins_id_cd, nvl(sum(txncnt),0)txncntJ from tsfana where trans_id = 'S33 ' and dom_ext_in = '1 ' and trans_at > 100000 and settle_dt between startDate and endDate group by rcv_ins_id_cd)j
on a.rcv_ins_id_cd = j.rcv_ins_id_cd ) ninetyone ;
end;
请问下要如何解决呢？
[解决办法]
你先告诉我你想干什么？
还有这是语句出来是一条记录还是多条？
[解决办法]
如
1, 定义一个cursor
2, open declare_cursor for dynamicSQLstring
3, operate dynamic SQL
