Oracle ´æ´¢¹ý³ÌÖÐʹÓÃcursor Óαê±éÀúÊý¾Ý

 Ïȶ¨ÒåÒ»¸öcursor:
Procedure  P_MYPROC (
                                    PI_PARAM VARCHAR2
)IS
VI_A    VARCHAR2(10):='';
VI_B    VARCHAR2(20):='';
VI_C    VARCHAR2(30):='';
 --¶¨Òå
 CURSOR MYCUR IS
        SELECE T.A ,T.B, T.C
        from TBL_MYTABLE T;
BEGIN
     --´ò¿ª
     OPEN MYCUR;
     --±éÀú
     LOOP
         FETCH MYCUR
         INTO VI_A,VI_B,VI_C;
        
         --ÎÞÊý¾ÝʱÍ˳ö
         EXIT WHEN MYCUR%NOTFOUND;
          --DO SOMETHING HERE;
     END LOOP;
END P_MYPROC;