oracle 中常用语句集锦
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;