Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trigger on multiple columns

571744Jun 6 2007 — edited Jun 6 2007
Hello,

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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2007
Added on Jun 6 2007
3 comments
1,063 views