SQL & PL/SQL

Dear All,

I have requirement that, there is list of columns from more than one table, need to insert into log table whenever the column value get changed (any one column). Since it is big list of columns, I am avoid to use NOT EXISTS. Simply used MINUS. But the tables having 100 K records, and compare with 100K already inserted. The query used below:

SELECT CTA.IAGREEMENTSEQNO,

           CTA.SZLEGACYAGREEMENTNO,

           CTA.SZPRODUCTCODE,

           CMG.SZUNITCODE          SZALLOCATEDUNITCODE,

           CMG.SZCOLLECTORGRPCODE  SZALLOCATEDUNITID,

           CCA.DTCOLLECTORGRPDATE,

           CTA.DTFIELD6            DTCLASSIFICATION,

           CCA.IHIERARCHYSEQNO,

           CTA.SZCPCCATEGORY,

           CTA.DTFIELD6,

           CTA.SZFIELD20,

           CTA.SZBUCKETCODE,

           CTA.SZFIELD12,

           CTA.IODDAYS,

           CTA.SZBOMCASETYPE,

           CCA.SZALLOCTYPE,

           CTA.SZSTATUS,

           (CASE WHEN CTA.FAMTUNDSETTL>0 THEN 'Y' ELSE 'N' END) CSETTLEMENTFLAG,

           CTA.DTCHEQUE DTBOUNCE,

           CTA.SZLOCATIONCODE,

           CTA.FINSTAMT,

           CTA.FOVERDUEOTHERAMT,

           CTA.FOVERDUEAMT,

           CTA.FOVERDUEPRINAMT,

           CTA.FOVERDUEINTAMT,

           CTA.FOSPRINAMT,

           CTA.FOSINTAMT,

           CTA.FFIELD3 FINSTALODAMT,

           CTA.IVINTAGEEXPMONTH,

           CTA.FLASTPAYMENTAMT,

           CTA.DTPAYMENT,

           CTA.SZRISKCODE,

           CCA.SZWFCODE,

           CCA.CTRUNKYN

      FROM COL_TRN_AGREEMENT      CTA,

           COL_CUR_AGREEMENTALLOC CCA,

           COL_MST_COLLECTORGROUP CMG

     WHERE CTA.SZORGCODE = CCA.SZORGCODE

       AND CTA.SZPARTITIONCODE = CCA.SZPARTITIONCODE

       AND CTA.IAGREEMENTSEQNO = CCA.IAGREEMENTSEQNO

       AND CCA.SZORGCODE = CMG.SZORGCODE

       AND CCA.SZCOLLECTORGRPCODE = CMG.SZCOLLECTORGRPCODE

       AND CTA.SZORGCODE = P_ORGCODE

       AND CTA.SZPARTITIONCODE = P_SZPARTITIONCODE

    MINUS

    SELECT IAGREEMENTSEQNO,

           SZLEGACYAGREEMENTNO,

           SZPRODUCTCODE,

           SZALLOCATEDUNITCODE,

           SZALLOCATEDUNITID,

           DTALLOCATION,

           DTCLASSIFICATION,

           IHIERARCHYSEQNO,

           SZCPCCATEGORY,

           DTCPCSTAMPING,

           SZQUEUECODE,

           SZBUCKETCODE,

           SZBOMBUCKET,

           IODDAYS,

           SZBOMCASETYPE,

           SZALLOCTYPE,

           SZSTATUS,

           CSETTLEMENTFLAG,

           DTBOUNCE,

           SZBRANCHCODE,

           FINSTAMT,

           FTOTCHRGODAMT,

           FTOTAMTDUE,

           --FAMTOD,

           FOVERDUEPRINAMT,

           FOVERDUEINTAMT,

           FOSPRINAMT,

           FOSINTAMT,

           FINSTALODAMT,

           IVINTAGEEXPMONTH,

           FLASTPAYMENTAMT,

           DTPAYMENT,

           SZRISKCODE,

           SZWFCODE,

           CTRUNKYN

      FROM COL_LOG_AGRLOGTRACKING;

Are there any other way to check whether the list of columns from different tables, changed or not.