Select For Update newbie question.

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:01:24 CDT