Re: PL/SQL Question

K Stahl <BlueSax_at_Unforgetable.com> wrote:
> amerar_at_unsu.com wrote:

[..]

> Instead of using a "for update" clause, just add the rowid of the row that
> you wish to update to your select statement and then when you do the update
> use the rowid in the where clause. That way you avoid all of the locks that
> are a result of the "for update", yet you still have the speed of not
> having to look the row up with a value.
And what would happen when after you fetched row and before you would update it someone would delete this row and insert with the same rowid ?

-- 
----------------------------
E-mail: fia_at_ins.dn.ua