oracle 多表插入

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;