Re: Will UPDATE lock if FROM refers to target table?

Carlo Stonebanks wrote:
> If I do an update using the FROM clause, and that clause has a sub-query
> that refers to the table I am updating, will I be waiting for ever for a
> table to lock to release?

You cannot block yourself with a lock, if that's what you mean.
The locks your session takes out will only block other sessions.

Yours,
Laurenz Albe