Oracle - Trigger for delete, insert, update

Hi everyone,

I made the following trigger:

create or replace trigger deptneu_2_ins_upd_del
after update on deptneu_2
begin

if inserting then
dbms_output.put_line ('insert!');
end if;

if updating then
dbms_output.put_line ('upgedate!');
end if;

if deleting then
dbms_output.put_line ('delete!');
end if;
end;
/


but only if I update the table the trigger is working. What could be wrong?

Another question: if I change the attribute "location" the trigger should tell the old value as well as the new one? Could anyone tell me how to do that?

Thank you very much in advance!

Peter

You need to change

after update on deptneu_2

to

after update,insert,delete on deptneu_2


use :new and :old variables to reference the two records.

E.g.

IF :new.location <> :old.location THEN
-- loction has changed
END;

Thank you very much, shammat!
Peter

Just for the record: this is something that can easily be looked up in the manual