Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Are these suppose to be equivalent?

Are these suppose to be equivalent?

From: <Stephen.Lee_at_DTAG.Com>
Date: Tue, 28 Sep 2004 11:06:08 -0500
Message-ID: <F5340B0E4DA1B64E906D328077060B2102170B1E@dtagpo2.dtg.local>

On the tables I have here, in a 9.2.0.4 database, the following produce the same update. The question is: Should they? That is, is this something the SQL spec says is supposed to work this way, or is this just some more subquery magic being applied by the Oracle optimizer. The intent is to update a column in one table (planb_location) with the corresponding values from another table (location).

Received on Tue Sep 28 2004 - 11:01:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US