student表有多少个学生,就要往A表和B表插入多少条数据,取student表的id:
begin
for item in (select id from student) loop
insert into tableA values(item.id,'','');
insert into tableB values(item.id,'','');
end loop;
end;
/
注意事项:虽然只查了一列,item也不是默认等于id的,还是要用 item.id