1、按行取出
DECLARE CURSOR test_c IS SELECT s.id staff_id, s.entrydate entrydate, d.id dimission_id, l.id liquidation_id FROM t_oa_staff s LEFT JOIN t_oa_dimission d ON d.delete_flag = '0' AND d.create_user = s.id LEFT JOIN t_oa_liquidation l ON l.delete_flag = '0' AND l.create_user = s.id WHERE s.delete_flag = '0'; test_row test_c%ROWTYPE; BEGIN FOR test_row IN test_c LOOP INSERT INTO t_oa_staff_workdate (sw_id, staff_id, sw_entrydate, dimission_id, liquidation_id,create_user) VALUES (seq_staff_workdate.NEXTVAL, test_row.staff_id, test_row.entrydate, test_row.dimission_id, test_row.liquidation_id,'60'); END LOOP; COMMIT; END;2、取出结果集
DECLARE CURSOR mycur IS SELECT dt.id FROM t_oa_department dt WHERE DT.DELETE_FLAG = '0' AND dt.id NOT IN (187, 189); BEGIN FOR varA IN mycur LOOP INSERT INTO T_OA_JOBTITLE (id, DEPART_CODE, name, kind) VALUES (SEQ_JOBTITLE.NEXTVAL, varA.id, '一般员工', 144); END LOOP; COMMIT; END;