Oracle批量insert数据

--表结构相等
insert into A select * from B where B.type='A';

--部分字段
insert into A(id,name) select B.id,B.name from B where B.type='A';