缓慢变化思想6

 --not key words
  vv_task_pos := 'insert into t_e_fsi_link_mid1 no keywords ';
  insert into t_e_fsi_link_mid2
    (customer_id,
     link_type_id,
     biz_org_id,
     fsi_core_product_id,
     status,
     first_active_time,
     has_read_condition,
     link_account_id,
     modify_time,
     version,
     last_change_date,
     fsi_link_pk,
     customer_status,
     status_change_time)
    select mid.customer_id,
           mid.link_type_id,
           mid.biz_org_id,
           mid.fsi_core_product_id,
           mid.status,
           mid.first_active_time,
           mid.has_read_condition,
           mid.link_account_id,
           mid.modify_time,
           mid.version,
           mid.last_change_date,
           mid.fsi_link_pk,
           mid.customer_status,
           mid.status_change_time
      from t_e_fsi_link_mid mid
     where not exists
     (select 1
              from t_e_fsi_link_mid1 mid1
             where mid1.customer_id = mid.customer_id
               and mid1.biz_org_id = mid.biz_org_id
               and mid1.fsi_core_product_id = mid.fsi_core_product_id
               and mid1.first_active_time = mid.first_active_time);

  commit;