> and of course it affected all the rows , bu i want update only
> the inserted row
>
> any help ?

Use before insert trigger and assign new value to :NEW.FIELD.

SY, SD.