declare cursor admin_cur is select admininfo_id,admininfo_name from admininfo;
beginfor my_cur in admin_cur loopupdate project set admininfo_id=my_cur.admininfo_id where PROJECT_RESPONSIBILITY=my_cur.admininfo_name;end loop;end;本文共 282 字,大约阅读时间需要 1 分钟。
declare cursor admin_cur is select admininfo_id,admininfo_name from admininfo;
beginfor my_cur in admin_cur loopupdate project set admininfo_id=my_cur.admininfo_id where PROJECT_RESPONSIBILITY=my_cur.admininfo_name;end loop;end;转载于:https://www.cnblogs.com/sallet/p/3833189.html