hi ,
i have to update a field of a table when a new record of the same table
is inserted .

i am tryng to use an after insert trigger , i tryed

..
update test_table s
set s.kyriga = 'test' ;
..

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

any help ?


thanks

Maurizio