I'm pretty new to triggers, but have a requirement to update a 2nd table based on Insert, Update and Delete to one main table.
So when PS_DEPT_TBL has either update, insert or delete action, I need it to update PS_IWAY_CTL table. The columns on PS_IWAY_CTL table include:
ACTION (INSERT, UPDATE, DELETE)
DATE (CURRENT DATE AND TIME)
The Primary key on PS_DEPT_TBL is SETID.
CREATE TRIGGER PS_DEPT_TBL_TRG
AFTER INSERT, UPDATE, DELETE