Using UPDATE

You can embed the UPDATE statement in a program in any of the forms that Modifying Data describes with the additional feature that you can name host variables in expressions, both in the SET and WHERE clauses. Moreover, a program can update the row that a cursor addresses.