触发器例子：

create or replace trigger MYTRIG after insert or update or delete
on DEPT for each row
declare
integrity_error exception;
NEWID integer;
NEWNAME varchar2(50);
NEWADDRESS varchar2(50);
begin
NEWID :=:NEW.DEPTNO;
NEWNAME :=:NEW.DNAME;
NEWADDRESS :=:NEW.LOC;
if inserting then
insert into TMP001(id,NAME,address) values (NEWID,NEWNAME,NEWADDRESS);
DBMS_OUTPUT.PUT_LINE(‘更新后值 ：’ || :NEW.DEPTNO);
END IF;
END;