Title: Reference the current row with the WHERE CURRENT clause.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Using Cursors

Reference should include

- describing where in a PL/SQL program code the FOR UPDATE clause is allowed and where the WHERE CURRENT OF clause is allowed
- writing a program in PL/SQL that
  - performs an UPDATE
  - uses the FOR UPDATE clause in the query to lock the rows
  - uses the WHERE CURRENT OF to update the row.