select not exists

 

 INSERT INTO acc_nofeenocharge_subs

               (subsoid, accoid, groupid)

      SELECT OID, accountoid, MOD (ROWNUM, 10)

        FROM tbcs.subscriber a

       WHERE NOT EXISTS (

                SELECT 1

                  FROM bill b

                 WHERE b.subsid = a.OID

                   AND b.acctid = a.accountoid     ---两张表有相同记录ＩＤ的不插入数据

                   AND billcycle = v_cycle3)

         AND a.stat us NOT LIKE ' US2%'                        --为US2%类的，不管是否记录相同，这部份数据都需要处理．

         AND a.stat us NOT IN (' US40', ' US345', ' US365')      --申请停机的不回收