On Thu, 2004-12-23 at 13:56, Mark wrote:
> Hi,
> Is it possible to lock row(s) when updating a table, so another call
> for update( from different session) will be rejected and to be on
> hold until lock get released ?
Generally the update itself will lock the table from other updates until
your transaction either commits or rolls back. OR are you looking for
something like select for update to lock a row to be used to update
another row?