insert_student_

来自「一个挺好的招生管理系统」· 代码 · 共 16 行

DECLARE
 		V_bh number;
  		V_zf number;
CURSOR score_cursor IS SELECT 号码,总分 FROM score;
BEGIN
OPEN score_cursor;  
loop
FETCH score_cursor INTO V_bh,V_zf;
update student set 总分=V_zf where 编号=V_bh;
exit when score_cursor%NOTFOUND;
  END LOOP;
  CLOSE score_cursor;
END;
/
commit;