Re: Select For Update newbie question.

see http://asktom.oracle.com and search. Tom Kyte is the best ! Rui Brito

"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 Thu Aug 08 2002 - 01:41:33 CEST