usually CURSORS are not required for updation of the table
Note that UPDATE operations can be performed in one of two ways:
1) By performing a searched update operation
Ex: UPDATE EMPLOYEES SET SALARY = NULL
UPDATE EMPLOYEES SET SALARY = SALARY * 1.08
WHERE EMP_ID = 30301
2) By performing a positioned update operation.
To perform a positioned update, a cursor must first be created, opened, and positioned on the row that is to be updated. Then, the UPDATE statement that is to be used to modify one or more data values must contain a WHERE CURRENT OF [CursorName] clause (CursorName identifies the cursor being used—we'll look at cursors shortly). Because of their added complexity, positioned update operations are typically performed by embedded SQL applications.
SET SALARY = :WS-SALARY
WHERE CURRENT OF CURSOR_1