共 1 篇文章
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;
2010-04-08 23:57 · 数据库