Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to lock record instead of lock tab?
Yes. It locks all the records the satisfy the where clause.
To lock a table, use the lock table statement.
Regards,
--
Sybrand Bakker, Oracle DBA
Dmitry Sirotkin <sdmitry1_at_mail.ru> wrote in message
news:87bmmm$19j$1_at_news.rinet.ru...
>
> Karsten Schwarz wrote in message <38993DD1.9252A9B2_at_secco.de>...
> >It's simply the same:
> >
> >select * from table where key_column = value for update.
> >
> >With the for update clause you will lock all the rows selected.
> >
> >=8-)
> >Karsten
>
> O-o-ps, I thought that SELECT ... FOR UPDATE only locks the last fetched
> record, but not all the selected records. Am I wrong?
>
> Dmitry.
>
>
Received on Thu Feb 03 2000 - 05:19:58 CST