oracle触发器实例

Create Or Replace Trigger tri_zfcg_pbjc
After Insert
On 表名
Referencing New As new_value
For Each Row
Declare
声明变量
Begin
--变量赋值
     v_id:=:new_value.ywlsh;
     v_opid:=:new_value.opid;
     v_optime:=:new_value.optime;
     v_pbsj:=:new_value.pbsj;
     v_zjrs:=:new_value.slrs+:new_value.qtrs;
     v_zjbl:=:new_value.slrs/v_zjrs;
     Select ywlsh,xmmc,zbbh,cgfs,status Into v_ywlsh,v_xmmc,v_zbbh,v_cgfs,v_status From T_YW_ZFCG_MAIN Where Id = v_id ;
      If v_pbsj<v_kbsj Then
        Begin
         语句
        End;
      Else
        Begin
          语句
        End;
      End If;
   End;