存储过程-test

select t.eqp_dcp_id as EQP_ID ,t.start_date as BEGIN_TIME,t.end_date as END_TIME,count(1) as cnt    
  from facadm.cpk_report t  
  where t.last_modify_date > a   
        and t.last_modify_date <= b   
        and t.eqp_dcp_id = eqp_dcp_id   
        group by t.eqp_dcp_id,t.start_date,t.end_date; 

 

 

伊一他妈,存储过程如下:

create or replace procedure testCountEQP(a in varchar2,b in varchar2,  
                                    eqp_dcp_id  in number) is  
  cursor reportCur is  
   select t.eqp_dcp_id as EQP_ID ,t.start_date as BEGIN_TIME,t.end_date as END_TIME,count(1) as cnt    
  from facadm.cpk_report t  
  where t.last_modify_date > a   
        and t.last_modify_date <= b   
        and t.eqp_dcp_id = eqp_dcp_id   
        group by t.eqp_dcp_id,t.start_date,t.end_date;  
begin  
set serveroutput on;  
dbms_output.put_line('EQP_ID    BEGIN_TIME      END_TIME        Records Count');    
for cur1 in reportCur loop  
  
dbms_output.put_line(cur1.EQP_ID ||'    '||cur1.BEGIN_TIME||'       '||cur1.END_TIME||'     '||cur1.cnt);  
end loop  
  
end;