oracle 存储过程 没报错 运行通过 就是添加不上数据

xiao224269 xiao224269 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
第一次写,求大神指点.
CREATE OR REPLACE PROCEDURE P_USER_STATISTICS IS
time DATE;
cursor userStatistics is
select * from (
select t1.register_num register_num,
t2.recharge_num recharge_num,
t3.apply_loan_sum apply_loan_sum,
t4.invest_num invest_num,
t5.sys_register_sum sys_register_sum,
t6.pc_register_sum pc_register_sum,
t7.wap_register_sum wap_register_sum,
t8.app_register_sum app_register_sum,
t9.login_sum login_sum
from
(select count(1) as register_num from users us where us.is_allow_login = '1' and trunc(us.time) = trunc(sysdate)) t1,

(select count(distinct urd.user_id) as recharge_num from user_recharge_details urd where urd.is_completed = '1'and trunc(urd.time) = trunc(sysdate)) t2,

(select count(distinct b.user_id) as apply_loan_sum from bids b where trunc(b.time) = trunc(sysdate)) t3,

(select count(distinct inv.user_id) as invest_num from invests inv where trunc(inv.time) = trunc(sysdate)) t4,

(select count(1) as sys_register_sum from users us where us.channel_id = '1' and trunc(us.time) = trunc(sysdate)) t5,

(select count(1) as pc_register_sum from users us where us.channel_id = '0' and us.is_allow_login = '1'and trunc(us.time) = trunc(sysdate)) t6,

(select count(1) as wap_register_sum from users us where us.channel_id = '2' and us.is_allow_login = '1'and trunc(us.time) = trunc(sysdate)) t7,

(select count(1) as app_register_sum from users us where us.channel_id = '3' and us.is_allow_login = '1'and trunc(us.time) = trunc(sysdate)) t8,

(select count(1) as login_sum from users us where trunc(us.last_login_time) = trunc(sysdate)) t9

);
us userStatistics%rowtype;

BEGIN
select to_char(sysdate,'yyyy/MM/dd') time
into time
from dual t;
for us in userStatistics loop

INSERT INTO Statistic_Behavior
(id,
time,
register_num,
recharge_num,
apply_loan_sum,
invest_num,
sys_register_sum,
pc_register_sum,
wap_register_sum,
app_register_sum,
login_sum)
values
(SEQ_STATISTIC_BEHAVIOR.NEXTVAL,
time,
us.register_num,
us.recharge_num,
us.apply_loan_sum,
us.invest_num,
us.sys_register_sum,
us.pc_register_sum,
us.wap_register_sum,
us.app_register_sum,
us.login_sum);

END loop;
commit;
end;
...全文

相关推荐

评论 15
收藏 已收藏
分享
返回顶部
xiao224269
Oracle 17,133 成员 55,258 内容