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;
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
