Determine the Type of Modifcation Operation on a Table

Sometimes, when you’re working with PL/SQL trigger code, you need to determine the type of modification operation that’s been performed on the ‘triggered’ table. You can do this using the INSERTING, DELETING and UPDATING trigger predicates. The following code demonstrates, using the trigger Tr on table Ta:

create or replace trigger Tr  after insert or delete or update on Ta -- don't forget this line  for each rowdeclare  begin  if deleting then         -- some code    end if;     if inserting then    -- some code  end if;      if updating then    -- some code  end if;end Tr;
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: