Before, After Insert or Update or Delete plsql trigger example.
A pl sql tutorial to understand Before, After Insert or Update or Delete trigger on table. This pl sql tutorial will give you a good concept of how to write pl sql triggers. Here is one example of the trigger
create or replace trigger trigger_name
before insert or update or delete on table_name
for each row
begin
if inserting then dbms_output.put_line('Before inserting on table');
elsif updating then dbms_output.put_line('Before updating on table');
elsif deleting then dbms_output.put_line('Before deleting on table');
end if;
end;
Video Length: 23:16
Uploaded By: Subhroneel Ganguly
Published: 10/26/2014
View Count: 33,867