几个Oracle procedure实例
create or replace procedure PC_TB_HTTPTASK_RESULT_TMP IS
v_http_targetalias varchar2(300);
v_http_dns_avgrtt number;
v_http_avgrtt number;
v_http_firstbyte_avgrtt number;
v_http_body_avgrtt number;
v_http_avgspeed number;
v_http_pagesize number;
v_http_opentimertt NUMBER;

CURSOR c_httptask_result IS
SELECT HTTP_TARGETALIAS,
       AVG(HTTP_DNS_AVGRTT) HTTP_DNS_AVGRTT,
       AVG(HTTP_AVGRTT) HTTP_AVGRTT,
       AVG(HTTP_FIRSTBYTE_AVGRTT) HTTP_FIRSTBYTE_AVGRTT,
       AVG(HTTP_BODY_AVGRTT) HTTP_BODY_AVGRTT,
       AVG(HTTP_AVGSPEED) HTTP_AVGSPEED,
       MAX(HTTP_PAGESIZE) HTTP_PAGESIZE
FROM (SELECT OBJECTID,
       HTTP_TARGETALIAS,
       HTTP_DNS_AVGRTT,
       HTTP_AVGRTT,
       HTTP_FIRSTBYTE_AVGRTT,
       HTTP_BODY_AVGRTT,
       HTTP_AVGSPEED,
       HTTP_PAGESIZE
  FROM TB_HTTPTASK_RESULT
WHERE
   TO_CHAR(COLTIME, 'YYYY-MM-DD') = TO_CHAR(SYSDATE-1, 'YYYY-MM-DD')
   AND HTTP_TARGETALIAS IS NOT NULL) TB_HTTPTASK_RESULT_CON
   
  WHERE
   OBJECTID IN
       (SELECT GROUPTASKID
          FROM GROUPTASK
         WHERE GROUPTASKID IN
               (SELECT TASKID
                  FROM GROUPTASKRELATION
                 WHERE GROUPID IN
                       (SELECT PROBEGROUPID
                          FROM TB_TASK_INFO
                         WHERE ID IN
                               (SELECT TASK_ID
                                  FROM TB_TASK_RELATION
                                 WHERE GROUP_ID IN
                                       (SELECT ID
                                          FROM TB_TASK_GROUP
                           &