1:  insert all

   2:      when sum_orders < 10000 then

   3:          into small_customers

   4:      when sum_orders >= 10000 and sum_orders < 100000 then

   5:          into medium_customers

   6:      else

   7:          into large_customers

   8:  select customer_id, sum(order_total) sum_orders

   9:  from oe.orders

  10:  group by customer_id;

  11:   

  12:  -- 注意上例是仿照

  13:  insert into scott.bonus(ename, job, sal)

  14:  select ename, job, sal from scott.emp;

   1:  update employees2

   2:  set (salary, first_name) = ( select salary * 10, last_name

   3:                                   from employees

   4:                               where employees.employee_id = employees2.employee_id)

   5:  where department_id = 90;

   1:  delete from (select * from employees2 where department_id = 90);