RE: Are these suppose to be equivalent?
- From: Stephen.Lee@xxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 28 Sep 2004 12:36:50 -0500
I thought this looked liked a correlated subquery and wondered if, perhaps,
it might be called a correlated update. And it is! This was never covered
in any SQL class or reading that I have done. asktom has a little
discussion on it, including (I think) how to handle the NOT 1:1 case (Thanks
M. Powell.). Search asktom (or even google) for "correlated update".
Now, the question I have is: Between the correlated update, and the "for
update/where current of", is one method inherently better than the other?
Or is it six of one and a half dozen of the other? It depends? Either way
appears to lock all the updated rows.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
