trigger on multiple columns
571744Jun 6 2007 — edited Jun 6 2007Hello,
I am using the following trigger to update another table. Currently, the trigger fires on a change of the employee_id, but I need the trigger to fire if there is a change in any of the following columns: employee_id, first_name, last_name. Do I need to create a seperate trigger for each column or can this be combined into one?
thanks, sck10
create or replace TRIGGER "TG_EMPLOYEE_GEN"
AFTER INSERT OR DELETE OR UPDATE
OF EMPLOYEE_ID
ON EMPLOYEE
BEGIN
RIGHTS_GEN_UPDATE_PKG.RightsUserMapGenUpdate ('UpdateGen');
END;