TRIGGER en oracle 10g.

[sir_joshua]

mmm no amigo, si pongo:

create or replace trigger promedio
after update or insert on mitabla
for each row
declare
media number;
begin
select (:new.c1 + :new.c2)/2
into media
from dual;
:new.media := media;
end;
/

************

create or replace trigger promedio
after update or insert on mitabla
for each row
begin
:new.media (:new.c1 + :new.c2)/2;
end;
/

tambien marca error .... nose como se te ocurriria que podria kedar bien..?

salu2.