RowTriggerSample.sql

CREATE OR REPLACE TRIGGER TRIGGER1
AFTER INSERT OR UPDATE 
ON TABLE1
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW WHEN (NEW.ID > 100)
declare
    -- ローカル変数
    is_xxx    boolean;
    param1    varchar2(1);
begin

    if INSERTING then
        insert into TABLE2 (id, column1, column2) values ( :new.id ,
:new.column1, :new.column2);

    elsif UPDATING then
        update  TABLE2
           set  COLUMN1 = :new.column1
               ,COLUMN2 = :old.column2
         where  id = :new.id
        ;

    end if;

exception
    when others then
        raise;
end;
/