1:有条件的
insert all
when customer_id < 1000 then
into small_customers
when customer_id >= 1000 and customer_id < 10000 then
into medium_customers
else
into large_customers
select customer_id, sum_orders from orders;
2:无条件的
insert all
into small_customers
into medium_customers
into large_customers
select customer_id, sum_orders from orders;
oracle 多表插入,布布扣,bubuko.com
oracle 多表插入
原文：http://www.cnblogs.com/working/p/3673466.html
