问问oracle触发器

riapguh 发布于 2006-01-02 20:48， 997 次点击

create table AAA
(
A VARCHAR2(44),
B VARCHAR2(44),
C VARCHAR2(44),
D VARCHAR2(44),
E VARCHAR2(44)
)
CREATE OR REPLACE TRIGGER "UPDATE_AAA_CDD" BEFORE
INSERT
OR UPDATE OF "A", "B", "C", "D", "E" ON "DZSW"."AAA" REFERENCING OLD AS OLD_VALUE NEW AS AAA FOR EACH ROW
when (aaa.c='2' )
begin

:aaa.d:='f';

end;
我怎么让aaa.c='2'时aaa.d的值等于aaa.a的值呢？

2 回复

love20082006-02-06 00:12

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

xibeilang2006-02-12 12:11