oracle 存储过程 没报错 运行通过 就是添加不上数据
第一次写,求大神指点.
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;
...全文
相关推荐
ORACLE如何使用存储过程实现添加、修改、删除、查询
在Oracle数据库中,存储过程是一种预编译的代码块,可以接受输入参数,执行复杂的数据库操作,并返回结果或状态。本文将深入探讨如何利用Oracle存储过程实现数据的添加、修改、删除和查询功能。
ORACLE存储过程实现添加、修改、删除、查询
在Oracle数据库环境中,存储过程是一种预编译的代码块,用于执行特定的数据库操作,如数据的添加、修改、删除和查询。
Oracle存储过程及调用
Oracle存储过程是数据库管理系统中的一种重要特性,它允许开发者封装一系列的SQL语句和PL/SQL代码,以实现更复杂的业务逻辑。
oracle存储过程编译错误问题
对于“Oracle Net Manager添加图解.doc”这个文件,可能是关于如何使用Oracle Net Manager配置网络连接的指南,这对于远程访问数据库和解决网络相关的存储过程编译问题非常有帮助
oracle数据库中查看系统存储过程的方法
总的来说,理解和掌握在Oracle数据库中查看和管理存储过程是数据库开发和维护的关键技能。这不仅涉及基本的查询操作,还包括对Oracle对象类型的理解,以及如何在不同编程语言中调用这些存储过程。


