René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

insert all [Oracle SQL]

Also called: Multi-Table insert. 
create table a (c number);
create table b (c number);
create table c (c number);

insert into a values (1);
insert into a values (42);
insert into a values (100);

commit;

insert all into b values(c) into c values (c) select c from a;
rollback;

insert all into b into c select c from a;
select * from b;
rollback;