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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: UPDATE SQL

RE: UPDATE SQL

From: <Stephen.Lee_at_DTAG.Com>
Date: Wed, 13 Oct 2004 08:45:38 -0500
Message-ID: <F5340B0E4DA1B64E906D328077060B2102B677EE@dtagpo2.dtg.local> 






This seems to be a case for a "correlated update".  Google on that, and see
what you find. 



>-----Original Message-----

>I don wanna run seperate queries for each row in PROFILE_SP_TYPE_CD.

>Cause my PROFILE_CUSTOMERS have more than 50000 records and this will

>be the pump running every nite.

>

>Can I update that in a single SQL Statement?


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Oct 13 2004 - 08:41:19 CDT












Original text of this message













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