Re: Help to create a Trigger.

v734> create table t (col number);

Table created.

v734> create table t2 (col number);

Table created.

v734> create or replace trigger my_t before insert or update or delete on t   2 for each row
  3 begin

  4     if inserting then
  5        insert into t2 values (:new.col);
  6     elsif updating then
  7        update t2 set col=:new.col where col=:old.col;
  8     else
  9        delete t2 where col = :old.col;
 10     end if;

Trigger created.

v734> insert into t values(0);

1 row created.

v734> select * from t2;

       COL

         0

1 row selected.

v734> update t set col=1 where col=0;

1 row updated.

v734> select * from t2;

       COL

         1

1 row selected.

v734> delete t ;

1 row deleted.

v734> select * from t2;

no rows selected

--
Have a nice day
Michel


José Gregório <jgregorio_at_inforlandia.pt> a écrit dans le message :
397EF587.B3F27F21_at_inforlandia.pt...


>

> Hi!

>

>

> I need to create a trigger.

>

> when an insert, update, delete occurs at a table i should execute the

> same operation on other table, for each row.

>

> How can i build the trigger?

>

>

> Best regards,

>

>         GreG.

>

>

>

>