Re: Select For Update newbie question.

Select for Update takes an exclusive row lock - on the assumption that you're going to make a change (you've used select for update and not select) and so noone else should be able to lock that row until you've commited your changes.

Try the Oracle SQL Reference rather than the App Dev Guide. The concepts manual is also a worth while read.

Andy

"vchkam" <vchkam_at_yahoo.com> wrote in message news:3fcf1c2f.0208050201.3b7f826a_at_posting.google.com...
> Hi all,
>
>
> I am a newbie to the oracle database. Recently, while reading about
> SQL statements, I came across the select for update statement. At
> first, it appears to me that select for update will accquire a row
> share lock. However, in some other places I read, it appears to me
> that select for update actually accquires a row exclusive lock. Can
> someone please tell me which lock does select for update really
> accquires. Also, can anyone tell me if there is a official link for
> Oracle SQL. I found the Oracle9i Application Developer's Guide, but
> it doesn't seem to be what I need, I needed documentations on basic
> Oracle SQL (something on the insert statements, update, etc.). Any
> input would be greatly appreciated. I appologize if I have posted to
> the wrong newsgroup.
>
>
> Thanks in advance,
>
> Vic
Received on Mon Aug 05 2002 - 05:46:18 CDT