SQL adaptation guide For Oracle Database 9.2, 10.x, 11.x, 12x / BDL programming |
Informix® allows positioned UPDATEs and DELETEs with the "WHERE CURRENT OF cursor" clause, if the cursor has been DECLARED with a SELECT ... FOR UPDATE statement.
UPDATE/DELETE ... WHERE CURRENT OF<cursor> is not support by the Oracle database API. However, ROWIDs can be used for positioned updates/deletes.
UPDATE/DELETE ... WHERE CURRENT OF instructions are managed by the ORACLE database interface. The ORACLE database interface replaces "WHERE CURRENT OF cursor" by "WHERE ROWID=:rid" and sets the value of the ROWID returned by the last FETCH done with the given cursor.