begin
? for cur in (select userid, username from t_a) loop
??? insert into t_b (xx, xx) values (cur.userid, cur.username);
? end loop;
? commit;
end;
日期:2014-05-16 浏览次数:20483 次
begin
? for cur in (select userid, username from t_a) loop
??? insert into t_b (xx, xx) values (cur.userid, cur.username);
? end loop;
? commit;
end;