java写触发器例子_简单的oracle触发器例子

简单的oracle触发器例子

---术前访视术后随访触发器

create or replace trigger t_update_trigger

after update or insert or delete

on MED_SMARTREPORT_TEMPLATE

for each row

declare

stateCount number;

begin

select count(1) into stateCount from MED_Template_State where ReportTemplateID=:NEW.ReportTemplateID;

if stateCount>0 then

update MED_Template_State set ReportState=ReportState+1 where ReportTemplateID=:NEW.ReportTemplateID;

else

insert into MED_Template_State(ReportTemplateID,ReportState) values(:NEW.ReportTemplateID,1);

end if;

end;

select * from MED_Template

select * from MED_ANESTHESIA_INPUT_DICT for update;

---数据字典触发器

create or replace trigger trigger_MEDANESTHESIAINPUTDICT

after  insert or update  or delete

on MED_ANESTHESIA_INPUT_DICT

for each row

declare

stateCount number;

begin

select count(1) into stateCount from MED_Template_State where ReportTemplateID=3;

if stateCount>0 then

update MED_Template_State set ReportState=ReportState+1 where ReportTemplateID=3;

else

insert into MED_Template_State(ReportTemplateID,ReportState) values(3,1);

end if;

end;

--select * from MED_Template_State

select * from MED_ANAESTHESIA_DICT for update;

select * from MED_Template_State

---麻醉字典触发器

create or replace trigger trigger_MEDANAESTHESIADICT

after  insert or update  or delete

on MED_ANAESTHESIA_DICT

for each row

declare

stateCount number;

begin

select count(1) into stateCount from MED_Template_State where ReportTemplateID=4;

if stateCount>0 then

update MED_Template_State set ReportState=ReportState+1 where ReportTemplateID=4;

else

insert into MED_Template_State(ReportTemplateID,ReportState) values(4,1);

end if;

end;

posted on 2010-07-14 16:59 sanmao 阅读(625) 评论(0)  编辑  收藏