simple trigger

[vrkeesara]

create or replace trigger xy
before insert or update on ccc
for each row
begin
If inserting then
:new.x := :new.y+:new.z;
end if;
If updating then

:new.x := ld.y+ld.z;
end if;
end;