This code snip demonstrates the practical use of "for update of" and "current of" facilities in oracle. "For update of" puts a lock on the column mentioned in the select statement. As a result, the column is locked during the updating of that column.

During the coupon merging, the coupons of the current of clauses hold that record to be updated which is being pointed by the cursor.