Oracle的触发器

Create Or Replace Trigger Jt_Webg_Xpxx_Insert_Tri
    After Insert Or Update On Jkxx_Xpxx
    For Each Row
/*
  2018-11-20
  created by lhl
  */
Declare

    Ls_Czzt Jkxx_Xpxx.Czzt%Type := Null;
Begin
    If Inserting Then
        Ls_Czzt := 'I';
    Else
        Ls_Czzt := 'U';
    End If;
    Insert Into Jkxx_Xpxx
        (Spxxid, Spzlid, Spjzid, Cbflid, Cbsid, Bbid, Kbid, Zzid, Yzid, Yxbzid,
         Spbh, Txm, Pm, Csm, Dj, Jj, Sl, Cbny, Bc, Yc, Yssj, Yz, Bz, Dps, Ym, Cd,
         Kd, Gd, Tj, Mbzl, Mbts, Mtcs, Mtzl, Tzflag, Zthflag, Ybsflag, Zfflag,
         Ztflag, Cuser, Uuser, Cdate, Udate, Jz, Drztflag, Gysid, Bzccflid,
         Gysspid, Spsxid, Fscsm, Zz, Bzqsp, Bzq, Rkqxfm, Ckqx, Scjj, Sjsl,
         Yxflid, Cbflmc, Nj, Cc, Km, Zsm, Bben, Zzhang, Zs, Sys, Bzhe, Yzhe,
         Hzhe, Wwm, Tzsh, Fjlxid, Ssbh, Jldwid, Ppid, Isdzs, Ispod, Gjz, Nrjj,
         Zzjj, Ml, Fmtp, Bjtj, Cwflid, Dzdx, Isxs, Sptp, Lspxxid, Xsxxqx, Nrjjtp,
         Htflid, Qkmc, Nyf, Qs, Qksx, Jylsj, Fxsid, Dplx, Yylx, Gs, Zmyy, Pyyy,
         Pc, Fxsj, Cdi, Minbn, Isth, Ys, Ccun, Cctj, Fybz, Lsid, Czzt)
    Values
        (:New.Spxxid, :New.Spzlid, :New.Spjzid, :New.Cbflid, :New.Cbsid,
         :New.Bbid, :New.Kbid, :New.Zzid, :New.Yzid, :New.Yxbzid, :New.Spbh,
         :New.Txm, :New.Pm, :New.Csm, :New.Dj, :New.Jj, :New.Sl, :New.Cbny,
         :New.Bc, :New.Yc, :New.Yssj, :New.Yz, :New.Bz, :New.Dps, :New.Ym,
         :New.Cd, :New.Kd, :New.Gd, :New.Tj, :New.Mbzl, :New.Mbts, :New.Mtcs,
         :New.Mtzl, :New.Tzflag, :New.Zthflag, :New.Ybsflag, :New.Zfflag,
         :New.Ztflag, :New.Cuser, :New.Uuser, :New.Cdate, :New.Udate, :New.Jz,
         :New.Drztflag, :New.Gysid, :New.Bzccflid, :New.Gysspid, :New.Spsxid,
         :New.Fscsm, :New.Zz, :New.Bzqsp, :New.Bzq, :New.Rkqxfm, :New.Ckqx,
         :New.Scjj, :New.Sjsl, :New.Yxflid, :New.Cbflmc, :New.Nj, :New.Cc,
         :New.Km, :New.Zsm, :New.Bben, :New.Zzhang, :New.Zs, :New.Sys, :New.Bzhe,
         :New.Yzhe, :New.Hzhe, :New.Wwm, :New.Tzsh, :New.Fjlxid, :New.Ssbh,
         :New.Jldwid, :New.Ppid, :New.Isdzs, :New.Ispod, :New.Gjz, :New.Nrjj,
         :New.Zzjj, :New.Ml, :New.Fmtp, :New.Bjtj, :New.Cwflid, :New.Dzdx,
         :New.Isxs, :New.Sptp, :New.Lspxxid, :New.Xsxxqx, :New.Nrjjtp,
         :New.Htflid, :New.Qkmc, :New.Nyf, :New.Qs, :New.Qksx, :New.Jylsj,
         :New.Fxsid, :New.Dplx, :New.Yylx, :New.Gs, :New.Zmyy, :New.Pyyy,
         :New.Pc, :New.Fxsj, :New.Cdi, :New.Minbn, :New.Isth, :New.Ys, :New.Ccun,
         :New.Cctj, :New.Fybz, Jkxx_Xpxx_Seq.Nextval, Ls_Czzt);
End Jt_Webg_Xpxx_Insert_Tri;

:new和:old

:new=>触发器改变之后的新值 

:old=>触发器改变之前的老值

截个屏先:说明一下触发器中的关键字=>