On Fri, 17 Jan 2003, Jon Swinth wrote:
> Now, if we could only have the feature like Oracle of SELECT ... FOR UPDATE
> NOWAIT, so I can control how long we wait for a lock. Wait... can't do that
> until SQL exceptions stop voiding the transaction (I want to be able to retry
> the lock several times before giving up).
What's Oracle's behavior when some of the rows can be locked and some
can't?