From: "Rui Brito" Newsgroups: comp.databases.oracle,comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools References: <3fcf1c2f.0208050201.3b7f826a@posting.google.com> Subject: Re: Select For Update newbie question. Date: Thu, 8 Aug 2002 00:41:33 +0100 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 NNTP-Posting-Host: 212.18.173.138 X-Original-NNTP-Posting-Host: 212.18.173.138 Message-ID: <3d51aef7@213.30.5.12> X-Trace: 8 Aug 2002 00:36:23 GMT, 212.18.173.138 Organization: Netc.pt Subscriber see http://asktom.oracle.com and search. Tom Kyte is the best ! Rui Brito "vchkam" wrote in message news:3fcf1c2f.0208050201.3b7f826a@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