A trigger saved to another table while the record of one table is deleted in oracle
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
