Hi,
Create local view, it is just like cursor. However, you can made any changes to the fields and update them to underlying table just by issuing TABLEUPDATE().
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...