Oracle-Insert all语句学习

1.测试数据

create table small_customers(customer_id number, orders number);create table medium_customers(customer_id number, orders number); create table large_customers(customer_id number, orders number); create table orders(customer_id number, sum_orders number);insert into orders values(1,9000);insert into orders values(1,10000);insert into orders values(1,100000);commit;kin@KIN>select * from orders;CUSTOMER_ID SUM_ORDERS----------- ----------  1  9000  1 10000  1100000

  

2.测试语句

insert allwhen sum_orders < 10000 theninto small_customerswhen sum_orders >=10000 and sum_orders < 100000 theninto medium_customerselseinto large_customersselect * from orders;kin@KIN>select * from small_customers;CUSTOMER_IDORDERS----------- ----------  1  9000kin@KIN>select * from medium_customers;CUSTOMER_IDORDERS----------- ----------  1 10000kin@KIN>select * from large_customersCUSTOMER_IDORDERS----------- ----------  1100000