create or replace trigger trg_demo
before update on tbname
for each row
begin
if :new.colname<>0 and :old.colname=0 then
insert into tb_bak values(:new.col1,:new.col2...);
end if;
end trg_demo;
/
before update on tbname
for each row
begin
if :new.colname<>0 and :old.colname=0 then
insert into tb_bak values(:new.col1,:new.col2...);
end if;
end trg_demo;
/
before UPDATE ON table_name FOR EACH ROW
BEGIN
if ...
insert into ....
END;
/
http://community.csdn.net/Expert/topic/3514/3514321.xml?temp=.249447
after update of col_name on table1
for each row
begin
if :new.col_name<>0 and :old.col_name=0 then
insert into table2 values(:new.col1,:new.col2,:new.col_name...);
end if;
end trg_demo;
/
有没有别的方法啊!!!我现在没办法,就用java监控一个触发器的结果表