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 row
declare
begin
if deleting then
-- some code
end if;
if inserting then
-- some code
end if;
if updating then
-- some code
end if;
end Tr;