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: Insert new record and update exist

Re: Insert new record and update exist

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Fri, 15 Aug 2003 16:16:44 +0100
Message-ID: <3F3CF95C.EDA2E6F0@hotmail.com> 







Mohammad wrote:


> 

> Hi,

> 

> I have problem to make query to check the Oracle table for update,if

> record is new inster that and if it is exist record just update that.

> 

> The insert record works fine. How do I can check if it is exits just

> update that.

> 

> Thank you for you help

> 

> Mohammad




The MERGE command will do this in version 9. No idea how efficient it
is, but I'd guess better than using PL/SQL.
Received on Fri Aug 15 2003 - 10:16:44 CDT












Original text of this message













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