实用小SQL
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;
暂无评论。
评论功能维护中,当前仅展示历史评论。