| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL AND LOCK
Matteo Lonardi wrote:
> I have to lock only one record (or a set of record) in PL/SQL.
> I have tried to use a cursor FOR UPDATE but it doesn't seem to work.
>
> Does anybody know how can I be able to do it?
>
> Thanks in advance.
>
> Matteo Lonardi
> teo_at_romeo.sci.univr.it
Try to use "FOR UPDATE t.column_name" where t - table alias.
Grinalds Received on Mon Sep 15 1997 - 00:00:00 CDT
![]() |
![]() |