Re: About concurent transaction, and reaction for lock

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 07 Nov 2002 22:28:50 +0100
Message-ID: <rlmlsu0u9f7dut6ds2vvbssk4pn2avcmim@4ax.com>

On Thu, 7 Nov 2002 20:09:41 +0200, "Alexander Kot" <Alexander.Kot_at_atlas.kiev.ua> wrote:

>I understand that, exists select .. for update no wait. But if I have
>triggers on this table, and it can concurrent for

for update no wait does the job.
An exception is unnecessary, because if you have a deadlock Oracle will resolve the deadlock.
Other than that it is very difficult to make any sense from your post.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Nov 07 2002 - 15:28:50 CST