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

For the triggers used in data synchronization in the previous work, the following notes are made and summarized as follows:

Data center

-- College

Create or replace trigger tger_XX_YXSDWJBSJZL_ist

Before insert on zfdxc.XX_YXSDWJBSJZL

For each row

Begin

Insert into xgxt.zxbz_xxbmdm@dblink_dxctoxgxt (bmdm,bmmc,bmjb,bmlb) values (: new.dwh,:new.dwmc,1,5)

End

/

Create or replace trigger tger_XX_YXSDWJBSJZL_udt

Before update on zfdxc.XX_YXSDWJBSJZL

For each row

Begin

Update xgxt.zxbz_xxbmdm@dblink_dxctoxgxt set bmdm=:new.dwh,bmmc=:new.dwmc where bmdm=:old.dwh

End

/

Create or replace trigger tger_XX_YXSDWJBSJZL_del

Before delete on zfdxc.XX_YXSDWJBSJZL

For each row

Begin

Delete zxbz_xxbmdm@dblink_dxctoxgxt where bmdm=:old.dwh

End

/

Create or replace trigger trig_xydmbtojwgl after INSERT OR DELETE OR UPDATE

Of dwh,dwmc ON xx_yxsdwjbsjzl FOR EACH ROW

BEGIN

IF INSERTING THEN

Insert into xydmb@dblink_dxctojwgl (xydm,xymc) values (: new.dwh,:new.dwmc)

Insert into xydmb@dblink_dxctozfoa (xydm,xymc) values (: new.dwh,:new.dwmc)

ELSIF DELETING THEN

Delete from xydmb@dblink_dxctojwgl where xydm=:old.dwh

Delete from xydmb@dblink_dxctozfoa where xydm=:old.dwh

ELSIF UPDATING THEN

Update xydmb@dblink_dxctojwgl set xydm=:new.dwh,xymc=:new.dwmc where xydm=:old.dwh

Update xydmb@dblink_dxctozfoa set xydm=:new.dwh,xymc=:new.dwmc where xydm=:old.dwh

END IF

END

/

-- Professional

Create or replace trigger tger_jx_zyxxsjl_ist

Before insert on zfdxc.jx_zyxxsjl

For each row

Begin

Insert into bks_zydm@dblink_dxctoxgxt (zydm,bmdm,zymc,zyjc,zyywmc) values (: new.zyh,:new.dwh,:new.zymc,:new.zyjc,:new.zyywmc)

End

/

Create or replace trigger tger_jx_zyxxsjl_udt

Before update on zfdxc.jx_zyxxsjl

For each row

Begin

Update bks_zydm@dblink_dxctoxgxt set zydm=:new.zyh,bmdm=:new.dwh,zymc=:new.zymc,zyjc=:new.zyjc,zyywmc=:new.zyywmc where zydm=:old.zyh

End

/

Create or replace trigger tger_jx_zyxxsjl_del

Before delete on zfdxc.jx_zyxxsjl

For each row

Begin

Delete bks_zydm@dblink_dxctoxgxt where zydm=:old.zyh

End

/

-- Class

Create or replace trigger tger_xx_bjsjl_ist

Before insert on zfdxc.xx_bjsjl

For each row

Begin

Insert into bks_bjdm@dblink_dxctoxgxt (bjdm,zydm,bmdm,bjmc,nj) values (: new.bh,:new.zyh,:new.ssxydm,:new.bj,:new.nj)

End

/

Create or replace trigger tger_xx_bjsjl_udt

Before update on zfdxc.xx_bjsjl

For each row

Begin

Update bks_bjdm@dblink_dxctoxgxt set bjdm=:new.bh,zydm=:new.zyh,bmdm=:new.ssxydm,bjmc=:new.bj,nj=:new.nj where bjdm=:old.bh

End

/

Create or replace trigger tger_xx_bjsjl_del

Before delete on zfdxc.xx_bjsjl

For each row

Begin

Delete bks_bjdm@dblink_dxctoxgxt where bjdm=:old.bh

End

/

-basic data of faculty

Create or replace trigger trig_jzgjcsjzl_jsxxb

After insert or delete or update of jgh,dwh,xm,xbm,csrq,jg,mzm,whcdm,jzglbm,zw

On jg_jzgjcsjzl for each row

Declare

V_bmmc varchar2 (100)

V_xb dm_gb_rdxbdm.mc%type

V_mz varchar2 (10)

V_whcdmc varchar2 (10)

V_jzglbmc varchar2 (10)

Maxxh varchar2 (100)

Kyyhbid varchar2 (20)

Kyyhjbxxbid varchar2 (20)

BEGIN

If: new.sjly=' Educational Administration 'then

Null

Else

Begin

Update kyglxtsequence@zfky_dblink set seqvalue=seqvalue + cachesize where seqname='SeqYHBID'

Update kyglxtsequence@zfky_dblink set seqvalue=seqvalue + cachesize where seqname='SeqYHJBXXBID'

Select seqvalue into kyyhbid from kyglxtsequence@zfky_dblink where seqname='SeqYHBID'

Select seqvalue into kyyhjbxxbid from kyglxtsequence@zfky_dblink where seqname='SeqYHJBXXBID'

End

Begin

Select dwmc into v_bmmc from xx_yxsdwjbsjzl where dwh=:new.dwh

Exception

When others then

Vaulting bmmcmistmisture 9'

End

Begin

Select mc into v_xb from dm_gb_rdxbdm where dm=:new.xbm

Exception

When others then

Vaulting xbfreuffle 9'

End

Begin

Select mc into v_mz from DM_GB_ZGGMZDLMZMPXFHDM where dm=:new.mzm

Exception

When others then

Vastly mzmistmistress 9'

End

Begin

Select mc into v_whcdmc from DM_HB_WHCD where dm=:new.whcdm

Exception

When others then

Vicious whcdmcmovudy

End

Begin

Select to_char (to_number (max (yhsx)) + 1) into maxxh from bmryxxb@dblink_dxctozfoa where xydm=:new.dwh

Exception

When others then

Maxxh:='-9'

End

Begin

Select mc into v_jzglbmc from DM_HB_JZGLB where dm=:new.JZGLBM

Exception

When others then

Vaulting jzglbmcmovudy

End

If inserting then

Insert into jsxxb@dblink_dxctojwgl (zgh,bm,xm,xb,csrq,jg,mz,xl,lbmc,sjly) values (: new.jgh,v_bmmc,:new.xm,v_xb,:new.csrq,:new.jg,v_mz,v_whcdmc,v_jzglbmc,' personnel')

Insert into bmryxxb@dblink_dxctozfoa (xydm,yhm,ryid,yhsx) values (: new.dwh,:new.jgh,bmryxx_ryid.nextval@dblink_dxctozfoa,maxxh)

Insert into yhjbxxb@zfky_dblink (yhjbxxbid,xm,xbdmbid,jgdmbid,xzzw) values (kyyhjbxxbid,:new.xm,:new.xbm,:new.dwh,:new.zw)

Insert into yhb@zfky_dblink (yhbid,yhm,mm,yhlybid,yhlyb,yhzt) values (kyyhbid,:new.jgh,'u',kyyhjbxxbid,'YHJBXXB','1')

Elsif deleting then

Delete from jsxxb@dblink_dxctojwgl where zgh=:old.jgh

Delete from bmryxxb@dblink_dxctozfoa where yhm=:old.jgh

Delete from yhjbxxb@zfky_dblink where xm=:old.xm

Delete from yhb@zfky_dblink where yhm=:old.jgh

Elsif updating then

Update jsxxb@dblink_dxctojwgl set zgh=:new.jgh,bm=v_bmmc,xm=:new.xm,xb=v_xb,csrq=:new.csrq,jg=:new.jg,mz=v_mz,xl=v_whcdmc,lbmc=v_jzglbmc where zgh=:old.jgh

Update bmryxxb@dblink_dxctozfoa set xydm=:new.dwh,yhm=:new.jgh,yhsx=maxxh where yhm=:old.jgh

Update yhjbxxb@zfky_dblink set xm=:new.xm where xm=:old.xm

Update yhb@zfky_dblink set yhm=:new.jgh where yhm=:old.jgh

End if

End if

End

/

Create or replace trigger trig_jzgjcsjzl_portalyhb

After insert or delete or update of jgh,xm

On jg_jzgjcsjzl for each row

BEGIN

If inserting then

Insert into yhb@dblink_dxctoportal (yhm,kl,xm,yhlx) values (: new.jgh,'u',:new.xm,'2')

Elsif deleting then

Delete from yhb@dblink_dxctoportal where yhm=:old.jgh

Elsif updating then

Update yhb@dblink_dxctoportal set yhm=:new.jgh,xm=:new.xm where yhm=:old.jgh

End if

END

/

Create or replace trigger trig_jzgjcsjzl_zfoayhb

After insert or delete or update of jgh,xm

On jg_jzgjcsjzl for each row

BEGIN

If inserting then

Insert into yhb@dblink_dxctozfoa (yhm,kl,zdm,xm,yhlx) values (: new.jgh,'u','21',:new.xm,'2')

Elsif deleting then

Delete from yhb@dblink_dxctozfoa where yhm=:old.jgh

Elsif updating then

Update yhb@dblink_dxctozfoa set yhm=:new.jgh,xm=:new.xm where yhm=:old.jgh

End if

END

/

Create or replace trigger trig_zyjszw_jsxxb after insert or delete or update of przwm on jg_zyjszwzl for each row

Declare

V_przwmc varchar2 (100)

BEGIN

Begin

Select zwxlmc into v_przwmc from dm_gb_zyjszwdm where dm=:new.przwm

Exception

When others then

Voluptuous przwmcmovudrou

End

Update jsxxb@dblink_dxctojwgl set zw=v_przwmc where zgh=:new.jgh

END

/

Create or replace trigger trig_zzmm_jsxxb

After insert or delete or update

Of zzmmm on jg_zzmmsjl for each row

Declare

V_zzmmmc varchar2 (100)

BEGIN

Begin

Select mc into v_zzmmmc from dm_gb_zzmmdm where dm=:new.zzmmm

Exception

When others then

Vaulting zzmmmcMorphology 9'

End

Update jsxxb@dblink_dxctojwgl set zzmm=v_zzmmmc where zgh=:new.jgh

END

/

-Student

Create or replace trigger tger_xs_xsjbsjzl_ist

Before insert on zfdxc.xs_xsjbsjzl

For each row

Begin

-basic information of students in the study-work system

Insert into xgxt.bks_xsjbxx@dblink_dxctoxgxt

(xh,bmdm,bjdm,zydm,xm,xmpy,cym,pyfs,xz,rxny,nj,sfzh,xbm,xjztm,xxnx,zyfx,ksh,bz,mm) values (: new.xh

(case when: new.xymc in (select dwmc from XX_YXSDWJBSJZl) then (select dwh from XX_YXSDWJBSJZl where)

: new.xymc=dwmc) else 'NU' end), (case when: new.bjmc in (select bj from xx_bjsjl) then (select bh from)

Xx_bjsjl where: new.bjmc=bj) else 'NULL' end), (case when: new.zydm is null then' NULL' else

: new.zydm end),: new.xm,:new.xmpy,:new.cym,:new.pyfs,:new.xz,:new.rxrq,:new.nj,:new.sfzjh, (case

New.xb when 'male' then 1 when 'female' then 2 else 0

End),: new.xjzt,:new.xxnx,:new.zyfx,:new.ksh,:new.bz,:new.mm)

-other information about students in the study-work system.

Insert into xgxt.bks_xsqtxx@dblink_dxctoxgxt (xh,mzdm,hkszd,byzx,lydq,csrq) values

(: new.xh,:new.mzm,:new.jg,:new.byzx,:new.lydq,:new.csrq)

-student password table of the student work system

Insert into xgxt.xsmmb@dblink_dxctoxgxt (xh,mm) values (: new.xh,:new.mm)

End

/

Create or replace trigger tger_xs_xsjbsjzl_udt

Before update on zfdxc.xs_xsjbsjzl

For each row

Begin

-basic information of students in the study-work system

Update xgxt.bks_xsjbxx@dblink_dxctoxgxt set xh=:new.xh,bmdm= (case when: new.xymc in (select dwmc from

XX_YXSDWJBSJZl) then (select dwh from XX_YXSDWJBSJZl where: new.xymc=dwmc) else 'NU' end), bjdm= (case)

When: new.bjmc in (select bj from xx_bjsjl) then (select bh from xx_bjsjl where: new.bjmc=bj) else

'NULL' end), zydm= (case when: new.zydm is null then' NULL' else: new.zydm end), xm= (case when: new.xm)

Is null then 'NULL' else: new.xm

End), xmpy=:new.xmpy,cym=:new.cym,pyfs=:new.pyfs,xz=:new.xz,rxny=:new.rxrq,nj=:new.nj,sfzh=:new.sfzjh

Xbm= (case: new.xb when 'male' then 1 when 'female' then 2 else 0

End), xjztm=:new.xjzt,xxnx=:new.xxnx,zyfx=:new.zyfx,ksh=:new.ksh,bz=:new.bz,mm=:new.mm where

Xh=:old.xh

-other information about students in the study-work system.

Update xgxt.bks_xsqtxx@dblink_dxctoxgxt set

Xh=:new.xh,mzdm=:new.mzm,hkszd=:new.jg,byzx=:new.byzx,lydq=:new.lydq,csrq=:new.csrq where xh=:old.xh

End

/

Create or replace trigger tger_xs_xsjbsjzl_del

Before delete on zfdxc.xs_xsjbsjzl

For each row

Begin

Delete xgxt.bks_xsjbxx@dblink_dxctoxgxt where xh=:old.xh

Delete xgxt.bks_xsqtxx@dblink_dxctoxgxt where xh=:old.xh

Delete xgxt.xsmmb@dblink_dxctoxgxt where xh=:old.xh

End

/

-

Personnel

Create or replace trigger trig_xydmbtozfdxc after INSERT OR DELETE OR UPDATE

Of code,info ON dm_def_org FOR EACH ROW

BEGIN

IF INSERTING THEN

Insert into xx_yxsdwjbsjzl@MEDI_DBLINK_zfdxc (dwh,dwmc) values (: new.code,:new.info)

ELSIF DELETING THEN

Delete from xx_yxsdwjbsjzl@MEDI_DBLINK_zfdxc where dwh=:old.code

ELSIF UPDATING THEN

Update xx_yxsdwjbsjzl@MEDI_DBLINK_zfdxc set dwh=:new.code,dwmc=:new.info where dwh=:old.code

END IF

END

/

CREATE OR REPLACE TRIGGER trig_overall AFTER INSERT OR DELETE OR UPDATE

-- of Xantiao STAFFIDGrad Xantian NAMEMagic NAMESPELLTECHEROLDNAMEREX.SEXKORTHDAYMY, SEXCONTONALITY XLYZONMETER, SEXCONTONALITYE, BORNPLACEE, IDCARDREX, WORKTIMERT, XYOLOTHSTATRT, XYOODTYPEX, XYLOLOSTATEX, MARRIAGESTATENE, XPRORTSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSONSO

ON overall FOR EACH ROW

BEGIN

IF INSERTING THEN

Insert into jg_jzgjcsjzl@MEDI_DBLINK_zfdxc (JGH,XM,XMPY,CYM,CSRQ,XBM,GJM,MZM,JG,CSDM,SFZJH,CJGZNY,JKZKM,XXM,GATQWM,HYZKM,JTCSM,BRCFM,DABH,LXRQ,DWH,WHCDM,BZLBM,JZGLBM,MM,xjxdm,zgxl,zgxw,rdsj,rzwsj) values (: new.X__STAFFID,:new.X__NAME,:new.X__NAMESPELL,:new.X__OLDNAME,:new.X__BIRTHDAY,:new.X__SEX,:new.X__NATIONALITY : new.X__NATION,:new.X__NATIVEPLACE,:new.X__BORNPLACE,:new.X__IDCARD,:new.X__WORKTIME,:new.X__HEALTHSTATE,:new.X__BLOODTYPE,:new.X__COLONY,:new.X__MARRIAGESTATE,:new.X__ORIGIN,:new.X__PERSONSTATION,:new.X__FILENO,:new.X__JOINCOLLEGETIME,:new.X__ORG,:new.X__EDUCATIONLEVEL,:new.X__AUTHSORT : new.X__STAFFSORT,'u',:new.X__FILENO,:new.X__EDUCATIONLEVEL,:new.X__DEGREE,:new.X__JOINDATE,:new.X__APPOINTDATE)

Insert into JG_ZYJSZWZL@MEDI_DBLINK_zfdxc (JGH,RZZGMCM,PRZWM) values (: new.X__STAFFID,:new.X__MAJORQUALIFICATION,:new.X__APPOINTDUTY)

Insert into JG_ZZMMSJL@MEDI_DBLINK_zfdxc (JGH,ZZMMM,CJRQ) values (: new.X__STAFFID,:new.X__POLITICS,:new.X__JOINDATE)

ELSIF DELETING THEN

Delete from jg_jzgjcsjzl@MEDI_DBLINK_zfdxc where jgh=:old.X__STAFFID

Delete from JG_ZYJSZWZL@MEDI_DBLINK_zfdxc where jgh=:old.X__STAFFID

Delete from JG_ZZMMSJL@MEDI_DBLINK_zfdxc where jgh=:old.X__STAFFID

ELSIF UPDATING THEN

Update jg_jzgjcsjzl@MEDI_DBLINK_zfdxc set JGH=:new.X__STAFFID,XM=:new.X__NAME,XMPY=:new.X__NAMESPELL,CYM=:new.X__OLDNAME,CSRQ=:new.X__BIRTHDAY,XBM=:new.X__SEX,GJM=:new.X__NATIONALITY,MZM=:new.X__NATION,JG=:new.X__NATIVEPLACE,CSDM=:new.X__BORNPLACE,SFZJH=:new.X__IDCARD,CJGZNY=:new.X__WORKTIME,JKZKM=:new.X__HEALTHSTATE XXM=:new.X__BLOODTYPE,GATQWM=:new.X__COLONY,HYZKM=:new.X__MARRIAGESTATE,JTCSM=:new.X__ORIGIN,BRCFM=:new.X__PERSONSTATION,DABH=:new.X__FILENO,LXRQ=:new.X__JOINCOLLEGETIME,DWH=:new.X__ORG,WHCDM=:new.X__EDUCATIONLEVEL,BZLBM=:new.X__AUTHSORT,JZGLBM=:new.X__STAFFSORT,XJXDM=:new.X__FILENO,ZGXL=:new.X__EDUCATIONLEVEL,ZGXW=:new.X__DEGREE RDSJ=:new.X__JOINDATE,RZWSJ=:new.X__APPOINTDATE where jgh=:old.X__STAFFID

Update JG_ZYJSZWZL@MEDI_DBLINK_zfdxc set JGH=:new.X__STAFFID,RZZGMCM=:new.X__MAJORQUALIFICATION,PRZWM=:new.X__APPOINTDUTY where jgh=:old.X__STAFFID

Update JG_ZZMMSJL@MEDI_DBLINK_zfdxc set JGH=:new.X__STAFFID,ZZMMM=:new.X__POLITICS,CJRQ=:new.X__JOINDATE where jgh=:old.X__STAFFID

END IF

END

/

-

Educational administration

-Campus

Create or replace trigger tger_xqdm_ist

Before insert on zfxfzb.xqdmb

For each row

Begin

Insert into xx_xqjbsjzl@dblink_jwgltodxc (xqh,xqm) values (: new.xqdm,:new.xqmc)

End

/

Create or replace trigger tger_xqdm_udt

Before update on zfxfzb.xqdmb

For each row

Begin

Update xx_xqjbsjzl@dblink_jwgltodxc set xqh=:new.xqdm,xqm=:new.xqmc where xqh=:old.xqdm

End

/

Create or replace trigger tger_xqdm_del

Before delete on zfxfzb.xqdmb

For each row

Begin

Delete xx_xqjbsjzl@dblink_jwgltodxc where xqh=:old.xqdm

End

-Professional

Create or replace trigger tger_zydm_ist

Before insert on zfxfzb.zydmb

For each row

Begin

Insert into jx_zyxxsjl@dblink_jwgltodxc (zyh,zymc,zyjc,zyywmc,dwh,xz,bzkzym) values (: new.zydm,:new.zymc,:new.zyjc,:new.zyywmc,:new.ssxydm,:new.xz,:new.tjzydm)

End

/

Create or replace trigger tger_zydm_udt

Before update on zfxfzb.zydmb

For each row

Begin

Update jx_zyxxsjl@dblink_jwgltodxc set zyh=:new.zydm,zymc=:new.zymc,zyjc=:new.zyjc,zyywmc=:new.zyywmc,dwh=:new.ssxydm,xz=:new.xz,bzkzym=:new.ssxydm where zyh=:old.zydm

End

/

Create or replace trigger tger_zydm_del

Before delete on zfxfzb.zydmb

For each row

Begin

Delete jx_zyxxsjl@dblink_jwgltodxc where zyh=:old.zydm

End

/

-Class

Create or replace trigger tger_bjdm_ist

Before insert on zfxfzb.bjdmb

For each row

Begin

Insert into xx_bjsjl@dblink_jwgltodxc (bh,bj,bzrjgh,fdyh,zyh,bjjc,zyfx,ssxydm,nj,ssxqdm,xz,cc) values (: new.bjdm,:new.bjmc,:new.bzrzgh,:new.fdyxm,:new.sszydm,:new.bjjc,:new.zyfx,:new.ssxydm,:new.nj,:new.ssxqdm,:new.xz,:new.cc)

End

/

Create or replace trigger tger_bjdm_udt

Before update on zfxfzb.bjdmb

For each row

Begin

Update xx_bjsjl@dblink_jwgltodxc set bh=:new.bjdm,bj=:new.bjmc,bzrjgh=:new.bzrzgh,fdyh=:new.fdyxm,zyh=:new.sszydm,bjjc=:new.bjjc,zyfx=:new.zyfx,ssxydm=:new.ssxydm,nj=:new.nj,ssxqdm=:new.ssxqdm,xz=:new.xz,cc=:new.cc where bh=:old.bjdm

End

/

Create or replace trigger tger_bjdm_del

Before delete on zfxfzb.bjdmb

For each row

Begin

Delete xx_bjsjl@dblink_jwgltodxc where bh=:old.bjdm

End

/

-- students

Create or replace trigger tger_xsjbxx_ist

Before insert on zfxfzb.xsjbxxb

For each row

Declare

V_bjdm varchar2 (50)

V_xydm varchar2 (50)

Begin

Begin

Select xydm into v_xydm from xydmb where xymc=:new.xy

Exception

When others then

Vaulting xydmchored nine.

End

Begin

Select bjdm into v_bjdm from bjdmb where bjmc=:new.xzb

Exception

When others then

Vandalism bjdmblol vault 9'

End

-data center student basic data subcategory

Insert into zfdxc.xs_xsjbsjzl@dblink_jwgltodxc (xh,xm,xmpy,cym,csrq,jg,sfzjh,xymc,zydm,zymc,bjmc,mz,pyfs,ksh,xxnx,xz,xb,zyfx,pyfx,xjzt,sfzx,sfzc,bz,nj,rxrq,LYDQ,BYZX,SSH,DZYXDZ,LXDH,ZKZH,JTSZD,SFLXS,TELNUMBER,TELLX,CC,YZBM,RXZF,YYCJ,zzmm,mm) values (: new.xh,:new.xm,:new.xmpy,:new.zym,:new.csrq,:new.jg,:new.sfzh : new.xy,:new.zydm,:new.zymc,:new.xzb,:new.mz,:new.xxxs,:new.ksh,:new.xxnx,:new.xz,:new.xb,:new.zyfx,:new.pyfx,:new.xjzt,:new.sfzx,:new.sfzc,:new.bz,:new.dqszj,:new.rxrq,:new.LYDQ,:new.BYZX,:new.SSH,:new.DZYXDZ,:new.LXDH,:new.ZKZH,:new.JTSZD,:new.SFLXS : new.TELNUMBER,:new.TELLX,:new.CC,:new.YZBM,:new.RXZF,:new.YYCJ,:new.zzmm,:new.mm)

-basic data subcategory of student status in data center

Insert into zfdxc.xs_xjjbsjzl@dblink_jwgltodxc (xh,yxsh,zym,bh) values (: new.xh,v_xydm,:new.zydm,v_bjdm)

End

/

Create or replace trigger tger_xsjbxx_udt

Before update on zfxfzb.xsjbxxb

For each row

Declare

V_bjdm varchar2 (50)

V_xydm varchar2 (50)

Begin

-data center student basic data subcategory

Begin

Select xydm into v_xydm from xydmb where xymc=:new.xy

Exception

When others then

Vaulting xydmchored nine.

End

Begin

Select bjdm into v_bjdm from bjdmb where bjmc=:new.xzb

Exception

When others then

Vandalism bjdmblol vault 9'

End

Update xs_xsjbsjzl@dblink_jwgltodxc set xh=:new.xh,xm=:new.xm,xmpy=:new.xmpy,cym=:new.zym,csrq=:new.csrq,jg=:new.jg,sfzjh=:new.sfzh,xymc=:new.xy,zydm=:new.zydm,zymc=:new.zymc,bjmc=:new.xzb,mz=:new.mz,pyfs=:new.xxxs,ksh=:new.ksh,xxnx=:new.xxnx,xz=:new.xz,xb=:new.xb,zyfx=:new.zyfx,pyfx=:new.pyfx,xjzt=:new.xjzt Sfzx=:new.sfzx,sfzc=:new.sfzc,bz=:new.bz,nj=:new.dqszj,rxrq=:new.rxrq,lydq=:new.LYDQ,byzx=:new.BYZX,ssh=:new.SSH,dzyxdz=:new.DZYXDZ,lxdh=:new.LXDH,zkzh=:new.ZKZH,jtszd=:new.JTSZD,sflxs=:new.SFLXS,TELNUMBER=:new.TELNUMBER,TELLX=:new.TELLX,cc=:new.CC,YZBM=:new.YZBM,RXZF=:new.RXZF,YYCJ=:new.YYCJ,zzmm=:new.zzmm,mm=:new.mm where xh=:old.xh

-basic data subcategory of student status in data center

Update xs_xjjbsjzl@dblink_jwgltodxc set xh=:new.xh,yxsh=v_xydm,zym=:new.zydm,bh=v_bjdm where xh=:old.xh

End

/

Create or replace trigger tger_xsjbxx_del

Before delete on zfxfzb.xsjbxxb

For each row

Begin

Delete xs_xsjbsjzl@dblink_jwgltodxc where xh=:old.xh

Delete xs_xjjbsjzl@dblink_jwgltodxc where xh=:old.xh

End

/

-- external teachers

Create or replace trigger trig_wpjs_zfdxc after insert or delete or update of zgh,xm,bm on jsxxb for each row

Declare

V_bmdm varchar2 (10)

Len number

Begin

Select count (jgh) into len from jg_jzgjcsjzl@dblink_jwgltodxc where jgh=:old.zgh and sjly=' personnel'

If len=0 and: new.sjly | | personnel data does not exist in then--

Begin

Select xydm into v_bmdm from xydmb where xymc=:new.bm

Exception

When others then

Vastly bmdmmovuzhuanglu 9'

End

If inserting then

Insert into jg_jzgjcsjzl@dblink_jwgltodxc (jgh,xm,dwh,sjly) values (: new.zgh,:new.xm,v_bmdm,' educational administration')

Elsif deleting then

Delete from jg_jzgjcsjzl@dblink_jwgltodxc where jgh=:old.zgh

Elsif updating then

Update jg_jzgjcsjzl@dblink_jwgltodxc set jgh=:new.zgh,xm=:new.xm,dwh=v_bmdm where jgh=:old.zgh

End if

End if

End

/

* all the content of this blog is original, if it is reproduced, please indicate the author and source!

Name: guoyJoe

QQ: 252803295

Email: oracledba_cn@hotmail.com

Blog: http://blog.csdn.net/guoyJoe

ITPUB: http://www.itpub.net/space-uid-28460966.html

OCM: http://education.oracle.com/education/otn/YGuo.HTM

_ _ _

Add-on validation question: which SGA structures are required and which are optional? Otherwise reject the application!

The answer is: http://blog.csdn.net/guoyjoe/article/details/8624392

Oracle@Paradise total group: 127149411

Oracle@Paradise No.1 group: 177089463 (full)

Oracle@Paradise No.2 group: 121341761

Oracle@Paradise No.3 group: 140856036

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.