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;