oracle 多表插入
时间：2014-04-19 05:10:04
收藏：0
阅读：443
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;
原文：http://www.cnblogs.com/working/p/3673466.html
评论（0）