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