兩個(gè)數(shù)據(jù)表，分別是ryxx和ryxx_b，要實(shí)現(xiàn)ryxx在修改的時(shí)候，立刻同步到ryxx_b對(duì)應(yīng)字段上面ryxx的表字段是ryxm、cardnum、ryidryxx_b的表字段是ryxm1、cardnum1、ryid1兩者的字段名是不一樣的CREATE OR REPLACE TRIGGER shitang?AFTER INSERT OR UPDATE OF ryxm ON RYXXFOR EACH ROWBEGININSERT INTO ryxx_b (ryxm1,cardnum1) VALUES (:NEW.RYXM1,:NEW.CARDNUM1);END;