oracle 存储过程，触发器遍历游标的三种方法

最新推荐文章于 2023-03-24 08:50:01 发布

hedd

最新推荐文章于 2023-03-24 08:50:01 发布

阅读量1.8k

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/hedandan160/article/details/39899831

版权

第一种：for循环v_tmp是变量无须指定(显示游标)

DECLARE
  CURSOR CUR IS SELECT * FROM TR_STUDENT_PARENT WHERE PARENT_ID = :NEW_VALUE.USER_ID;
   BEGIN
     FOR V_TMP IN CUR LOOP
       SELECT STUDENT_NO INTO V_STUDENTNO FROM TU_STUDENT WHERE STUDENT_ID = V_TMP.STUDENT_ID;
       INSERT INTO UNIPLATFORM_PARENT(SCHOOL, STUDENTNO, DN, PARENTNAME, RELATION, SPID, PARENTFLAG, PARENTID) VALUES(V_SCHOOLNAME, V_STUDENTNO, :NEW_VALUE.DN, :NEW_VALUE.USER_NAME, V_TMP.RELATION, V_SPID, 2, :NEW_VALUE.USER_ID);
  END LOOP;
END;

第二种：for循环v_tmp是变量无须指定(隐式游标)

DECLARE
BEGIN
 FOR V_TMP IN (SELECT STUDENT_ID, RELATION FROM TR_STUDENT_PARENT WHERE PARENT_ID = :NEW_VALUE.USER_ID) LOOP
   SELECT STUDENT_NO INTO V_STUDENTNO FROM TU_STUDENT WHERE STUDENT_ID = CUR.STUDENT_ID;
   INSERT INTO UNIPLATFORM_PARENT(SCHOOL, STUDENTNO, DN, PARENTNAME, RELATION, SPID, PARENTFLAG, PARENTID) VALUES(V_SCHOOLNAME, V_STUD