Re: Which query is best?
- From: Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx>
- To: Rumpi Gravenstein <rgravens@xxxxxxxxx>
- Date: Tue, 15 Dec 2009 19:09:52 +0300
Hi Rampui,
The UPDATE is intended for a single row only. I appreciate if you can
further explain me about the other ... more optimistic ways you thought
about whilst doing a single row UPDATE.
On Tue, Dec 15, 2009 at 6:06 PM, Rumpi Gravenstein <rgravens@xxxxxxxxx>wrote:
> <snip>They have explained me that, they have a
> SELECT .. FOR UPDATE and some other series of actions and then followed by
> </snip>
>
> Question -- is the update intended to update a single row or a set of
> rows? If the answer is a single row, then there are other ... more
> optimistic ... ways to get the lock that don't involve using the FOR
> UPDATE clause.
>
>
> --
> Rumpi Gravenstein
>
--
Best Regards,
Syed Jaffar Hussain
Oracle Certified Master (10g)
http://www.oracle.com/technology/ocm/shussain.html
Oracle ACE
http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186
OCP 8i,9i & 10g DBA
RAC Certified Expert
Official Oracle RAC SIG Representative for Saudi Arabian region (
http://www.oracleracsig.org/)
I blog at
http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/pub/syed-jaffar-hussain/2/a71/918
--------------------
"Winners don't do different things. They do things differently."
Other related posts:
