NO_DATA_FOUND跟||变量组装和for循环的代码实例

NO_DATA_FOUND和||变量组装和for循环的代码实例

?

    FOR i in 1 .. (JB_DIFF_COUNT - 1) loop      SELECT DM_XZQH_PARENT        INTO VI_SJ_XZQH_PARENT        FROM DM_XZQH       WHERE DM_XZQH = VI_SJ_XZQH_PARENT;    END LOOP;