有表table1 create table( field1 number(5) );
表table2 create table( field2 number(5) );
想在table1有修改的时候作触发,将table1.field1的和计算后修改到table2.field2中,field2就一条记录.
谢谢,大侠帮忙啊!
表table2 create table( field2 number(5) );
想在table1有修改的时候作触发,将table1.field1的和计算后修改到table2.field2中,field2就一条记录.
谢谢,大侠帮忙啊!
after insert or update or delete on table1
FOR EACH ROW
begin
CASE
WHEN inserting THEN
update table2 set field2 = select sum(*) from table1;
WHEN updating THEN
update table2 set field2 = select sum(*) from table1;
WHEN deleting THEN
update table2 set field2 = select sum(*) from table1;
END CASE;
end;