SQL Developer Data Modeler

Dear members,

I have a table with multiple columns on each update on these columns I have to update another table columns.

for one column the following trigger is working fine, but there are about more than 10 columns which I have to check for.

I want to create only one after update trigger on this table and check which column is updated and update the same column in 2nd table.

here is the trigger:

CREATE OR REPLACE TRIGGER ABC_RATE_UPD
AFTER UPDATE
   OF RATE
   ON ABC_PCD  
   REFERENCING NEW AS New OLD AS Old
   FOR EACH ROW
DECLARE
  BEGIN

    UPDATE RM_TRAN_IN
    SET RATE = :NEW.RATE
    WHERE RM_PCD_ID = :NEW.RM_PCD_ID;
   EXCEPTION
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END ABC_RATE_UPD;

here is my if condition, (edited)

if :NEW.RATE != :OLD.RATE then
    
        UPDATE ABC_TRAN_IN
        SET RATE = :NEW.RATE
        WHERE ABC_PCD_ID = :NEW.ABC_PCD_ID;

    ELSIF :NEW.PACK_UNIT_ID != :OLD.PACK_UNIT_ID then
    
        UPDATE ABC_TRAN_IN
        SET PACK_UNIT_ID = :NEW.PACK_UNIT_ID
        WHERE ABC_PCD_ID = :NEW.ABC_PCD_ID;
END IF;
    

Its working good, is this a good approach, to the solution?

regards:

Edited by: user2040934 on Dec 29, 2012 3:22 PM