trigger

[jmodic]

Originally posted by hrishy
Hi jurij

why do you think both of them will fire ?thanks pipo ia m also tryin to test this..:-)

I'm not guessing, I simply know.

SQL> create table test (c1 number);

Table created.

SQL> insert into test(c1) values(1);

1 row created.

SQL> commit;

Commit complete.

SQL> CREATE OR REPLACE TRIGGER trg1 AFTER UPDATE OF c1 ON TEST
  2  FOR EACH ROW
  3  BEGIN
  4    DBMS_OUTPUT.PUT_LINE('I''m the first trigger and I''ve just been fired');
  5  END;
  6  /

Trigger created.

SQL> CREATE OR REPLACE TRIGGER trg2 AFTER UPDATE OF c1 ON TEST
  2  FOR EACH ROW
  3  BEGIN
  4    DBMS_OUTPUT.PUT_LINE('I''m the second trigger and I''ve just been fired');
  5  END;
  6  /

Trigger created.

SQL> set serveroutput on
SQL> update test set c1 = 0;
I'm the second trigger and I've just been fired
I'm the first trigger and I've just been fired

1 row updated.