Re: About locking

if u wanted to lock the table when u are procedure is running the only what i know is using for update statement... specially if the volume of data is more.. if it is for less volumne... running for update.. my not make much difference which might not optimise ur code...

To find out about the lock in dictionary tables there are system tables available called v$lock..etc. but it represents in number. You should be aware about the
combination or the what each number
represents. If u can look at DBA Admin Guide.... there is some info available on it...

"Sbaiz" <pierluigi.sbaiz_at_elsag.it> wrote:
>Hi everyone.>
>I know is possible to lock a row with a for
update select statements.
>Are there any other solution to perform this
kind of lock with a statement?
>and how can I find out, into the Oracle
dictionary, if a row is locked?
>
>Thanks in advance.
>SbaizP.
>
>
Received on Tue Jul 06 1999 - 16:59:39 CDT