触发器的知识

触发器的知识 

 

• 触发器的定义就是说某个条件成立的时候，触发器里面所定义的语句就会被自动的执行。
• 因此触发器不需要人为的去调用，也不能调用。
• 触发器可以分为语句级触发器和行级触发器。

触发器语法

create [or replace] trigger 触发器名 触发时间 触发事件
on 表名
[for each row]
begin
 pl/sql语句
end

 

CREATE OR REPLACE TRIGGER TR_BI_T_FKHG_JFDJ
BEFORE INSERT OR UPDATE
ON T_FKHG_JFDJ
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
tmpVar NUMBER;
BEGIN
   begin
    select n_sjdm,n_szjdm,n_sxjdm into  :new.n_sjdm, :new.n_szdm, :new.n_sxdm from t_pub_jgdm where n_jgdm = :new.n_jgdm;
    EXCEPTION
     WHEN OTHERS THEN
     null;
    end;
    /*
   begin
    select t1.n_jgdm,t1.c_jgmc into  :new.N_CLJGDM, :new.C_CLJGMC from t_pub_jgdm t1, T_PUB_YGXX T2 where t2.N_YGGH = :new.N_CLYGGH AND T2.N_JGDM = t1.N_JGDM;
    EXCEPTION
     WHEN OTHERS THEN
     null;
    end;
*/

   EXCEPTION
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END ;