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;