update trigger

[isaacprasanna]

I have the following two tables budgetmain and mfr,
Every new entry in budgetmain table will result in fireing trigger of inserting 11 rows in MFR table,

the problem is, if I update in the budgetmain only one corresponding row in the MFR table must b update? How to write a trigger for it? Or how to find the value of the entire row which was updated??

actuallu I used this to find if the particular value was updates or not.
if :new.April != :old.April then
temp := :new.April;
select budseq into mno from budgetmain where :new.April != :old.April;
update mfr set BUDGETMONTH = temp where month = 'April';
end if;

now I want the entire record of the particular row, where the update was fired?

please help me..

[debasisdas]

try using the RETURNING clause.