1、刷数据
DECLARE
CURSOR T1 IS
SELECT * FROM wo;
BEGIN
FOR REC IN T1 LOOP
UPDATE wo w
SET W.wo_staff_id = REC.sgdd_id
WHERE W.WO_NBR = REC.WO_NBR;
END LOOP;
END;
1、刷数据
DECLARE
CURSOR T1 IS
SELECT * FROM wo;
BEGIN
FOR REC IN T1 LOOP
UPDATE wo w
SET W.wo_staff_id = REC.sgdd_id
WHERE W.WO_NBR = REC.WO_NBR;
END LOOP;
END;