概述
declare
--声明变量
v_sum_cnt number(10);
v_kxf_cnt number(10);
v_bkxf_cnt number(10);
begin
--1.获取批次总量、可下发量、不可下发量
select count(1),
sum(case
when (a.customer_status is null or
(a.latest_assigned_date <= add_months(sysdate, -6) and
a.customer_status = 'assigned')) then
1
else
0
end),
sum(case
when (a.customer_status is null or
(a.latest_assigned_date <= add_months(sysdate, -6) and
a.customer_status = 'assigned')) then
0
else
1
end)
into v_sum_cnt, v_kxf_cnt, v_bkxf_cnt
from cls_customer_info a, dm_custlist_upload_batch b
where a.upload_batch_id = b.batch_id
and a.upload_batch_id = IN_UPLOAD_BATCH_ID;
--2. 添加其他业务逻辑代码...
end;
----------------------分割线------------------------
一开始这样写的：
select count(1) into v_sum_cnt,
sum(case
when (a.customer_status is null or
(a.latest_assigned_date <= add_months(sysdate, -6) and
a.customer_status = 'assigned')) then
1
else
0
end)
into v_kxf_cnt,
sum(case
when (a.customer_status is null or
(a.latest_assigned_date <= add_months(sysdate, -6) and
a.customer_status = 'assigned')) then
0
else
1
end)
into v_bkxf_cnt
from cls_customer_info a, dm_custlist_upload_batch b
where a.upload_batch_id = b.batch_id
and a.upload_batch_id = IN_UPLOAD_BATCH_ID
;
编译时就报错咯：编译错误 PL/SQL: ORA-00934: group function is not allowed here.
转载于:https://my.oschina.net/MiniBu/blog/347102
最后
以上就是笨笨月饼为你收集整理的存储过程中同一语句多个聚合函数时 into 用法的全部内容，希望文章能够帮你解决存储过程中同一语句多个聚合函数时 into 用法所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复