MERGE Help
From: Marc A. Lefebvre US-775 <lefebvre_at_iwavesolutions.com>
Date: 28 May 2003 23:31:46 -0700
Message-ID: <5ef1a86c.0305282231.580c5df_at_posting.google.com>
Date: 28 May 2003 23:31:46 -0700
Message-ID: <5ef1a86c.0305282231.580c5df_at_posting.google.com>
I want to use the Oracle DML statement called MERGE. I understand the syntax and all but need help fomulating the INSERT and UPDATE clauses.
If I have a Table A and a Table B which have the same schema. I would like to insert Table A into Table B, for the records that dont exist, and update for the records that do exist for the Primary Key. What is the most efficient method to do this and what would the resulting MERGE statement look like.
Thanks!
Marc Received on Thu May 29 2003 - 08:31:46 CEST