CURSOR

--定义
CURSOR c_mycursor IS
select * from t_my_table t where ...

--使用
OPEN c_mycursor;
    LOOP
      FETCH c_mycursor INTO mycursor;
      EXIT WHEN c_mycursor%NOTFOUND;
      BEGIN
      ........
      END;
    END LOOP;
CLOSE c_mycursor;