实用小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;