hi,
i need help in writing this trigger
i have a block with mlti row records,one of the fieds is a date and the other is a serial number and another one is the amount
ex:
serno date amount
1 1/2/2005 300
2 1/3/2005
3 1/4/2005
4 1/5/2005

i need to update the record with serial number 2 by changing the date
add_months(date,2) that the amount null
so it would be 2 1/5/2005
i need to update the rest of records depending on the changed date
so it become like this
1 1/2/2005
2 1/5/2005
3 1/6/2005
4 1/7/2005
till last record
another case if the amount for date 1/3/2005 is not null i update will effect the next record and it would be like this:
1 1/2/2005
2 1/3/2005
3 1/5/2005
4 1/6/2005


thanks