CREATE OR REPLACE TRIGGER 名称
AFTER UPDATE
OF 字段1,字段2 ... ON 表名
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
integrity_error EXCEPTION;
声明变量
BEGIN
主题语句
EXCEPTION
WHEN integrity_error THEN
BEGIN
-- 例外信息
END;
END;
declare trigger tri_emp
before insert or delete or update on emp for each row
begin
if inserting then
dbms_output.put_line('插入操作');
elsif deleting then
dbms_output.put_line('删除操作');
elsif updating then
dbms_output.put_line('更新操作');
end if;
end;