1.无条件insert all
create table book_name(bname varchar2(20));
create table file_name(fname varchar2(20));
create table t_name(bname varchar2(20);
 
insert all into book_name values(bname) into file_name values(fname) select * from t_name;
 
2.条件
insert all when bname='IBM' then into a_name when bname='FIREFOX' then into b_name select * from t_name;