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

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP- Insert/Update Sloooow

Re: HELP- Insert/Update Sloooow

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 5 Jan 2005 10:01:23 -0800
Message-ID: <1104948083.228150.96960@f14g2000cwb.googlegroups.com>


If you are using Oracle 9i or later, look up the merge command, something like ...
Merge into <target_table tt > using <source_table st> on (<tt.col1 = st.col5 and tt.col2 = st.col1>)
when matched then update set <tt.colx = tt.colx + st.coly> when not matched then insert (<list of tt columns>) values (<list of st columns or expressions>) Received on Wed Jan 05 2005 - 12:01:23 CST

Original text of this message

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