Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 Wed Aug 07 2002 - 18:41:33 CDT
![]() |
![]() |