How to implement Updatable CURSOR

For Read-only cursor, maybe we can make a copy of results, but how to for updatable one. If with the same way, the consistency between copy cursor and real DB is a problem. If we only keep the location in DB, in order to prevent others modify those rows in result set, we must lock all these rows, which will influence the performance heavily.

Is anyone able to give some advice? Received on Sun Mar 17 2002 - 20:52:34 CST