On Thu, Aug 28, 2003 at 15:17:34 -0500,
Girish Bajaj <gbajaj@tietronix.com> wrote:
> Hello all,
>
>
>
> Is there a way I can force a more aggressive lock on a table in a SELECT
> statement that's being executed in a transaction?
>
>
>
> SELECT FOR UPDATE is not aggressive enough. I need an exclusive lock on that
> particular table the select is accessing.
You can use a LOCK statement to do this.