create OR REPLACE trigger trigger_name after insert OR update OR delete on table_a for each row begin if inserting then insert into table_a('列名') values(:NEW.列名); elsif updateing then update table_b set 列名=:NEW.列名 where 列名=:OLD列名; elsif deleting then delete from table_b where 列名=:OLD.列名; end if; end; /