OPEN O_OUTCURSOR FOR
SELECT ipcnt INTO R_Number1 FROM US_DAYREPORT a
INNER JOIN AD_MONPOINT b on a.pointid = b.pointid
and b.name LIKE '%注册%' WHERE a.arrid = I_ArrangeID
and a.accesstime = trunc(sysdate-1);
V_Register1 := V_Register1 + R_Number1;
请问我这样能实现累加吗
SELECT ipcnt INTO R_Number1 FROM US_DAYREPORT a
INNER JOIN AD_MONPOINT b on a.pointid = b.pointid
and b.name LIKE '%注册%' WHERE a.arrid = I_ArrangeID
and a.accesstime = trunc(sysdate-1);
V_Register1 := V_Register1 + R_Number1;
请问我这样能实现累加吗
解决方案 »
- 急救 Oracle UCM 安装
- 急,一个关于函数的问题
- 数据库链接问题?请帮忙
- 请看下面SQL语句,如何提高效率,畅所欲言,在线讨论!!!
- 触发器问题
- ORACLE
- 请问在developer 2000中后缀为fmx的文件是如何生成的?在线给分!
- win2000下oracle8i在enterprise manager 中备份数据老是报错,提示验证错误。
- 诸位大哥ORACLE的倒入倒出问题
- exists的用法,新人求助
- 想写一个程序,主要是写一句话“helloworld”到 一个test.txt文件中,我有一个问题,大家帮帮忙
- 我写个包,主要功能是从数据库中读数据,然后存到文件中,编译通过,数据也取出来了,但为什么写不到文件中呢?
OPEN O_OUTCURSOR FOR
SELECT ipcnt FROM US_DAYREPORT a
INNER JOIN AD_MONPOINT b on a.pointid = b.pointid
and b.name LIKE '%注册%' WHERE a.arrid = I_ArrangeID
and a.accesstime = trunc(sysdate-1);
fetch o_outcursor into R_Number1 ;
V_Register1 := V_Register1 + R_Number1;
是步是这个意思:
SQL> set serveroutput on;
SQL>
SQL> declare
2 V_Register1 int;
3 begin
4 V_Register1 := 0;
5 for rec in(select salary from hr.employees)
6 loop
7 V_Register1 := V_Register1+rec.salary;
8 end loop;
9 Dbms_Output.put_line(V_Register1);
10 end;
11 /691400PL/SQL procedure successfully completed