begin
for l_record in ( select colum_name1,colum_name2,colum_name.. from tablename1)
loop
insert into tablename2 (colum_name1,colum_name2,colum_name..)
VALUES (l_record.colum_name1,l_record.colum_name2,l_record.colum_name..);
commit;
end loop;
end;
前提:
tablename2 中有对应列