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;
