多筆更新. beign for rec in(select no2,name from t2) loop update t1 set no1=rec. no2 where name=rec.name end loop;
oracled2k.pixnet.net