编程论坛 » Oracle » 问问oracle触发器

riapguh 发表于 2006-1-2 20:48

问问oracle触发器

<P>create table AAA<BR>(<BR>  A VARCHAR2(44),<BR>  B VARCHAR2(44),<BR>  C VARCHAR2(44),<BR>  D VARCHAR2(44),<BR>  E VARCHAR2(44)<BR>)<BR>CREATE OR REPLACE TRIGGER "UPDATE_AAA_CDD" BEFORE<BR>INSERT<BR>OR UPDATE OF "A", "B", "C", "D", "E" ON "DZSW"."AAA" REFERENCING OLD AS OLD_VALUE NEW AS AAA FOR EACH ROW <BR>when (aaa.c='2' )<BR>begin</P>
<P><BR>      :aaa.d:='f';<BR>                   <BR>end;<BR>我怎么让aaa.c='2'时aaa.d的值等于aaa.a的值呢？<BR> </P>

love2008 发表于 2006-2-6 00:12

create or replace trigger trigger_name before insert on aaa for each row<BR> begin<BR> :new.d:=:new.a;<BR> end;<BR> /<BR> 我这里只写了插入的触发器,对于修改你只要自己修改一下就可以了...

xibeilang 发表于 2006-2-12 12:11

[em18]

查看完整版本: 问问oracle触发器