Shulou(Shulou.com)06/01 Report--

Create or replace trigger delete_SXCLGC_tri

After delete on winf_sv_ex_hybs_sxclgc

For each row

DECLARE

Begin

Insert into WINF_SV_EDITORIAL_DELETE (

SXBM,XH,HJBH,HJFZRXM

HJFZRSJ,HJFZRZWDM,HJFZRZWMC,HJMC

FZRSZBM,FZRSZBMZZJGDM,UNIT,ISSTARTESPECIALLYPROCEDURE

TIMELIMIT,ESPECIALLYPROCEDURETYPE,TBCXTIMELIMIT,QSBMZZJGDM)

Values (

: old.sxbm,:old.XH,:old.HJBH,:old.HJFZRXM

: old.HJFZRSJ,:old.HJFZRZWDM,:old.HJFZRZWMC,:old.HJMC

: old.FZRSZBM,:old.FZRSZBMZZJGDM,:old.UNIT,:old.ISSTARTESPECIALLYPROCEDURE

: old.TIMELIMIT,:old.ESPECIALLYPROCEDURETYPE,:old.TBCXTIMELIMIT,:old.QSBMZZJGDM)

End delete_SXCLGC_tri

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.