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;