CREATE OR REPLACE PROCEDURE prc_pm_cpu(in_portid integer, in_stime date, in_etime date) is v_value number; v_mincpuused number; v_maxcpuused number; begin begin select t.cpuused into v_mincpuused from s_pm_cpu t where t.portid = in_portid and t.starttime=in_stime;
select t.cpuused into v_maxcpuused from s_pm_cpu t where t.portid = in_portid and t.starttime=in_etime;
---------------- -------------------- ----------------
E0030015_CPU_789 2011-9-30 上午10:30:00 21
E0030015_CPU_789 2011-9-30 上午11:30:00 33
将这两个时间段的数据做一个差值
是计算指定的PORTID的,指定好的2个时间点的数据相减?
还是计算所有PORTID的,所有时间点的,每后面的一个送去前面的一个?
CREATE OR REPLACE PROCEDURE prc_pm_cpu(in_portid integer,
in_stime date,
in_etime date) is
v_value number;
v_mincpuused number;
v_maxcpuused number;
begin
begin
select t.cpuused
into v_mincpuused
from s_pm_cpu t
where t.portid = in_portid and t.starttime=in_stime;
select t.cpuused
into v_maxcpuused
from s_pm_cpu t
where t.portid = in_portid and t.starttime=in_etime;
v_value:=v_maxcpuused-v_mincpuused;
end;
commit;
end prc_pm_cpu;
不知道是不是这个意思
riqi-1/48 是减半个小时,riqi-1/24是减一个小时。