Multitable insert command

Multitable insert command conn hr/hr1, create test table SQL> create Table small_orders (order_id int, order_total number, sales_rep_id varchar2 (4), customer_id varchar2 (10); table created. SQL> create table medium_orders (order_id int, order_total number, sales_rep_id varchar2 (4), customer_id varchar2 (10); Table created. SQL> create table large_orders (order_id int, order_total number, sales_rep_id varchar2 (4), cust Omer_id varchar2 (10); Table created. SQL> create table orders (order_id int, order_total number, sales_rep_id varchar2 (4), customer_id varchar2 (10); Table created. 2. insert test data: insert into orders (order_id, order_total, sales_rep_id, customer_id) values (0001, '000000', '000000'); insert into orders (order_id, order_total, sales_rep_id, customer_id) values (0002, '000000', '000000'); insert into orders (order_ I D, order_total, sales_rep_id, customer_id) values (0003, '000000', '000000'); insert into orders (order_id, order_total, sales_rep_id, customer_id) values (0000000003, '123', '123'); insert into orders (order_id, order_total, sales_rep_id, customer_id) values (0004, '123', '123'); insert into orders (order_id, order_total, sales_rep_id, customer_id) values (0006, '000000', '000000'); 3, conditional multi-Table insertion (cond Itional insert all): insert all when order_total <10000 then into when order_total> = 10000 AND order_total <100000 then into medium_orders WHEN order_total> = 100000 then into large_orders SELECT order_id, order_total, sales_rep_id, customer_id FROM orders; 4, Insert FirstSQL> delete from small_orders; 2 rows deleted. SQL> delete from medium_orders; 2 rows deleted. SQL> delete from large _ Orders; 2 rows deleted. insert first when ottl <10000 then into small_orders VALUES (oid, ottl, sid, cid) WHEN ottl> = 10000 and ottl <100000 then into medium_orders VALUES (oid, ottl, sid, cid) WHEN ottl> = 100000 then into large_orders VALUES (oid, ottl, sid, cid) SELECT order_id oid, order_total ottl, sales_rep_id sid, customer_id cid FROM orders; 5, the difference between insert all and insert fi RstINSERT all when order_total <1000000 then into small_orders WHEN order_total <1000000 then into medium_orders WHEN order_total> = 10 then into explain SELECT order_id, order_total, distinct, customer_id FROM orders; 18 rows created. insert first when order_total <1000000 then into small_orders WHEN order_total <1000000 then into medium_orders WHEN order_total> = 10 THEN INT O large_orders SELECT order_id, order_total, sales_rep_id, customer_id FROM orders; 6 rows created. Only the first table small_orders inserts 6 records, and the other two tables are not inserted. From the two examples above, we can see the difference between insert first and insert all: insert first only checks the FIRST condition. If the FIRST condition is met, it will not check even if the second condition is met, the second condition is checked only when the first condition is not met. If the insert all condition is used, ALL conditions are checked;