oracle触发器

create or replace trigger CAll_CREATED_DATE

  after update  of X_HC_CREATED_DATE on S_SRV_REQ

  FOR EACH ROW

begin

  --if updating('X_HC_CREATED_DATE') then

  insert into HAPPYCALL_H

    (old_v, New_v, Row_Id, modify_d)

  values

    (:old.X_HC_CREATED_DATE, :new.X_HC_CREATED_DATE, :old.row_id, sysdate);

   -- end if;

END;