Create a trigger in Oracle

First, let's talk about the trigger concept: the trigger is a special database object caused by the execution of DML statements. Therefore, the insert, instead of update, and delete triggers are required.

The basic usage is shown below:

-- Create or replace trigger tri_deleteafter delete on EMP for each rowbegin Delete from EMP where empno = 7369; end; -- create an insert trigger create or replace trigger tri_insert after insert on for each rowbegin Insert into EMP values (?,?,?,?); End; -- create update/replace trigger create or replace trigger tri_updateinstead of update EMP on for each rowbegin Update EMP set ename = 'boda' where empno = 7369; end;