About Oracle Cursor

 CURSOR C_Temp IS
 SELECT bxa.*, biv.gtaid4, bxt.GTTDRI, bxd.GTDPID........

 From t_xxxxx

 

 c1 C_Temp%ROWTYPE;

 

   FOR c1 IN C_Temp --这种方式好像在结果集为空时会进入死循环
   LOOP

        --processing logic here.

   END LOOP;

 

  FOR C1 IN (SELECT xxxx  from xxxxyyyz)

  LOOP
      null;

  END LOOP;

 

   OPEN C_Temp;
   IF c_temp%ROWCOUNT = 0 THEN
     RETURN;
   END IF;

 

   LOOP
   FETCH c_temp INTO c1;
   EXIT WHEN c_temp%NOTFOUND;

        --processing logic here.

   END LOOP;

Published by Wiz